Results 1 to 2 of 2
2009-05-19, 05:29 #1
- Join Date
- May 2009
- Thanked 0 Times in 0 Posts
I am looking for some help in creating a directory mail merge and then emailing it to individuals. I have data in spreadsheet in the following format.
Publisher Books Email
PubA Title One firstname.lastname@example.org
PubA Title Two email@example.com
PubA Title Three firstname.lastname@example.org
PubB Book One email@example.com
PubB Book Two firstname.lastname@example.org
PubC One Volume email@example.com
PubD Another Text firstname.lastname@example.org
PubE First of Many Books email@example.com
PubE Second of Many Books firstname.lastname@example.org
PubE Third of Many Books email@example.com
PubE Last of Many Books firstname.lastname@example.org
I have created a directory mail merge in which I have got one letter for each publisher consisting of books list I need to order. i.e. One letter to PubA with all three titles. My letter varies with publisher according to number of books.
The problem I am facing is how to email these letters to just one email Id using outlook.
For example, I want to send my directory mail merge to Publisher PubA just once on his email email@example.com and not three times as shown in my excel spreadsheet.
I have tried merging with new documents and emailing but it mails all 5 letters together to all the emails present in the spreadsheet.
I want individual letters to specific recipients only.
I hope I have explained my problem.
Any feedback or help would be highly appreciated. Thanks in advance
2009-05-19, 06:14 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts