En curso

Create Mail Merge with Grouping a Key Field from Excel (VBA)

I have a large Database with the following info.

(Example 4 columns, each column separated with |, and replaced email with / )

[url removed, login to view] | Email | Product | Q |

SH1 | info/[url removed, login to view] | Orange | 105.566 |

SH1 |info/[url removed, login to view] | Berries | 200.000 |

BT1 |info/[url removed, login to view] | Orange | 300.000 |

BT4 |info/[url removed, login to view] | Apple | 101.700 |

WT1 |info/[url removed, login to view] | Berries | 201.040 |

WT6 | info/[url removed, login to view] | Apple | 204.000 |

[url removed, login to view] refers to Company_Name, and Q for quantity.

I need a mail merge that inserts an exclusive table using a key field to form the table.

In the dummy table before, the key field could be the company name, or the company mail.

For example

**Email**

from <hendrixspirit/[url removed, login to view]>

To: <emailcompany1>

Subject: Enquiry of <productname1>, <productname2>, ..., <productnamei>

Dear sirs from <company_name1>

In name of Hendrix Fundation, I'm requesting a price quotation and

availability of the following products so we can feed the people that is going to conmemorate

50 years of WoodStock Festival.

!-- Here it has to insert an specific table for the company name

!-- so it only shows the information regarding that company.!

Table<CompanyName1>

| Product | Q |

| Product 1 | Q. Prod 1 |

| Product 2 | Q. Prod 2 |

| Product ... | Q. Prod ...|

| Product i | Q. Prod i |

Regards

Hendrix Foundation Supply Manager

<end mail, and repeat for other company,

until there are no more companies..>

I've tried to do this with Word Mail Merge to Outlook using an Excel datasheet with a small dummy database.

I've found a page of microsoft support (en-us/kb/294686), but I have only been partialy succesfull: I can insert the data, but:

1) I can't add text after and showing it in the correct way, and two and more importat. I can't add a format of table that "changes".

I have a large database with varied data points and variables which will require many emails. I need a system that can handle this load.

To clarify: I need to Mail merge and insert an specific table regarding a Key Field** (in the dummy case the key field is they company_name or the company_email).

I'm fluent in SQL queries, use Microsoft SQL Server as the database, but I preffer to export the info from the SQL to an excel and the do the mail-merge.

I don't want to use SQL connections because i expect that people that don't use SQL would be able to use it at my office to.

Also bonus points if it's possible to attack a .pdf file to the mail merge (always the same file to each mail)

My expected solutions in order from better to worse.

1) a VBA "Macro" or code that provides what I'm asking

2) A Google Apps application that do the same but with Google SpreadSheet, google form, etc (we have google apps for work at the office.

2) Download a paid program that could do this. But I haven't been able to find it.

So to clarify for last time.

1) Grab information from a database with the format given before, and INSERT a table in the middle of the e-mail with the fields that are relevant for.

For example for SH1 the table would be:

| Orange | 105.566 |

| Berries | 200.000 |

But for BT1 it would be only one line:

| Orange | 300.000 |

Hipotetically there could be a company with infinite products, and also there could be infinite columns

for example (Product, Type, Price, Quantity)

| Orange | |Clementine | 5 USD |105.566 |

| Orange | Mandarine | 7 USD |55.566 |

I have program things on VBA and i know it's possible, but i'm not a programmer so i get lost on how to make the three programs talk togheter (Excel for Database, Word for template of Mail, Outlook for sending the e-mail).

I can provide dummy datasheet and clear example if needed. I also asked on stackoverflow with no answer, and had search in the web for some weeks and haven't found anything similar :S

I've added a dummy database on .xls that clarifies the project. This was asked for some freelancers. Hope that with this information you can provide your best offer.

Habilidades: Excel, Microsoft Outlook, Visual Basic para aplicaciones , Word

Ver más: vba excel mail merge, create microsoft server sbs, excel vba mail merge word document excel macro, excel vba excel macro mail merge word, word mail merge excel vba, vba mail merge excel word, vba create mail merge, mail merge pdf excel vba, excel database built links create mail merge pdfs, mail merge create pdf vba, mail merge template create email, word vba create mail merge, vba mail merge excel 2010 word 2010, excel vba mail merge pdf, extracting xml data using vba excel macros, excel vba load information, connect odbc use vba excel, use google finance spreadsheet functions excel, excel vba pull information website, vba excel manipulating spreadsheet, vba word information excel, mail merge 2003 create forms, can create odbc use vba excel, excel vba extract information word document, excel vba send outlook mail automatically

Información del empleador:
( 1 comentario ) Santiago, Chile

ID de proyecto: #11504036

Adjudicado a:

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. PS: I can Más

$100 USD en 5 días
(170 comentarios)
6.7

18 los freelancers están ofertando un promedio de $152 para este trabajo.

maverick44000

Hi Sir, I have gone through the requirements and I can write the required VBA script within 2 days. I am ready to accept payment, after you have tested the functionality. Please discuss so I may begin working on it. Más

$160 USD en 2 días
(98 comentarios)
7.3
deepbluetech

Hi, I am an Excel VBA expert and would be happy to take on your project. My solution is going to be Excel VBA based meeting your requirements. Regards, Arul

$150 USD en 3 días
(224 comentarios)
7.2
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have Más

$150 USD en 2 días
(182 comentarios)
7.0
shikhamehta

Hello there, I reviewed the requirements in detail and as you rightly mentioned, this needs some custom macro programming to be done. I would like to inform you that I have done almost similar setups for other cl Más

$333 USD en 7 días
(124 comentarios)
6.4
katilinas

Hello. 40 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$155 USD en 3 días
(93 comentarios)
5.9
abdolah2014

HI I am an excel-vba Expert and I have done a similar project for my own company I can finish your project so fast start chat to discuss more ....................................................................... Más

$222 USD en 5 días
(36 comentarios)
5.3
satishtl

- I have expertise in Excel automation, Outlook mailing and modifying the content, and Word automation. - Have done sending / modifiying the incoming mails and resending based on information, sending mails from Excel Más

$140 USD en 4 días
(38 comentarios)
5.2
$155 USD en 3 días
(66 comentarios)
5.2
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Más

$100 USD en 3 días
(33 comentarios)
4.6
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your ins Más

$120 USD en 3 días
(46 comentarios)
4.8
nineoneone

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y Más

$100 USD en 2 días
(15 comentarios)
4.3
hieutc

Hi, I've already done some VBA similar to this project, involving sending automated email from a text/word file. I've also do a lot of VBA for Excel automation, so I could do this project for you (including the atta Más

$150 USD en 3 días
(7 comentarios)
4.1
TulyakovN

Hello. Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$70 USD en 5 días
(5 comentarios)
2.8
solarqw

If you have php server, I can help you to write php code to help you to reformat the database and send email content. I can also use java code if your system have java environment. The process is simple, I just need t Más

$155 USD en 3 días
(5 comentarios)
2.6
nikita07

Can fulfill your requirement in a day. I am an excel guru and have worked on similar projects in past.

$222 USD en 3 días
(2 comentarios)
1.1
Engineer0786

Hi, I am professional in this task.I would like to assist you in your projects. Get it done professionally get it done right the 1st time. I am here to make long term relationship. I would like to get all details from Más

$155 USD en 3 días
(0 comentarios)
0.0
Femiabi

Hi there, I am confident; I can take up your project and do it with perfection. I have excellent communication skills with over 10 years experience in data entry. I can use ms-excel spreadsheet to compute any type Más

$100 USD en 3 días
(0 comentarios)
0.0