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.
from <hendrixspirit/[url removed, login to view]>
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.!
| Product | Q |
| Product 1 | Q. Prod 1 |
| Product 2 | Q. Prod 2 |
| Product ... | Q. Prod ...|
| Product i | Q. Prod i |
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.
18 los freelancers están ofertando un promedio de $152 para este trabajo.
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
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.