Hi All,
I am new to this forum. I couldn't find specific to Outlook group so posting here.
I am looking for some help in creating a directory mail merge. I have data in spreadsheet in the following format.
|
Publisher |
Books |
Email |
|
PubA |
Title One |
abc@test.com |
|
PubA |
Title Two |
abc@test.com |
|
PubA |
Title Three |
abc@test.com |
|
PubB |
Book One |
xyx@abc.com |
|
PubB |
Book Two |
xyx@abc.com |
|
PubC |
One Volume |
mnop@abd.net |
|
PubD |
Another Text |
email@newemail.com |
|
PubE |
First of Many Books |
last@last.edu.com |
|
PubE |
Second of Many Books |
last@last.edu.com |
|
PubE |
Third of Many Books |
last@last.edu.com |
|
PubE |
Last of Many Books |
last@last.edu.com |
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 abc@test.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.
-Aroma