A
Aroma
Hi All,
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 [email protected]
PubA Title Two [email protected]
PubA Title Three [email protected]
PubB Book One [email protected]
PubB Book Two [email protected]
PubC One Volume [email protected]
PubD Another Text [email protected]
PubE First of Many Books [email protected]
PubE Second of Many Books [email protected]
PubE Third of Many Books [email protected]
PubE Last of Many Books [email protected]
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 protected] 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
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 [email protected]
PubA Title Two [email protected]
PubA Title Three [email protected]
PubB Book One [email protected]
PubB Book Two [email protected]
PubC One Volume [email protected]
PubD Another Text [email protected]
PubE First of Many Books [email protected]
PubE Second of Many Books [email protected]
PubE Third of Many Books [email protected]
PubE Last of Many Books [email protected]
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 protected] 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