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

Selesai Dipasang 7 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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

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.

Excel Microsoft Outlook Visual Basic untuk Aplikasi Word

ID Proyek: #11504036

Tentang proyek

17 proposal Proyek online Aktif 7 tahun yang lalu

Diberikan kepada:

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 Lebih banyak

$100 USD dalam 5 hari
(196 Ulasan)
6.8

17 freelancer rata-rata menawar $152 untuk pekerjaan ini

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. Lebih banyak

$160 USD dalam 2 hari
(102 Ulasan)
7.6
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 Lebih banyak

$150 USD dalam 2 hari
(234 Ulasan)
7.4
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 dalam 3 hari
(229 Ulasan)
7.3
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 Lebih banyak

$333 USD dalam 7 hari
(128 Ulasan)
6.5
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 dalam 3 hari
(111 Ulasan)
6.4
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 ....................................................................... Lebih banyak

$222 USD dalam 5 hari
(37 Ulasan)
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 Lebih banyak

$140 USD dalam 4 hari
(44 Ulasan)
5.9
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 Lebih banyak

$100 USD dalam 2 hari
(20 Ulasan)
4.4
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 Lebih banyak

$150 USD dalam 3 hari
(7 Ulasan)
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 dalam 5 hari
(5 Ulasan)
2.8
nikita07

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

$222 USD dalam 3 hari
(2 Ulasan)
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 Lebih banyak

$155 USD dalam 3 hari
(0 Ulasan)
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 Lebih banyak

$100 USD dalam 3 hari
(0 Ulasan)
0.0