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 / ) [login to view URL] | Email | Product | Q | SH1 | info/[login to view URL] | Orange | 105.566 | SH1 |info/[login to view URL] | Berries | 200.000 | BT1 |info/[login to view URL] | Orange | 300.000 | BT4 |info/[login to view URL] | Apple | 101.700 | WT1 |info/[login to view URL] | Berries | 201.040 | WT6 | info/[login to view URL] | Apple | 204.000 | [login to view URL] 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/[login to view URL]> 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