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 (e-mail address removed)
PubA Title Two (e-mail address removed)
PubA Title Three (e-mail address removed)
PubB Book One (e-mail address removed)
PubB Book Two (e-mail address removed)
PubC One Volume (e-mail address removed)
PubD Another Text (e-mail address removed)
PubE First of Many Books (e-mail address removed)
PubE Second of Many Books (e-mail address removed)
PubE Third of Many Books (e-mail address removed)
PubE Last of Many Books (e-mail address removed)
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 (e-mail address removed) 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 (e-mail address removed)
PubA Title Two (e-mail address removed)
PubA Title Three (e-mail address removed)
PubB Book One (e-mail address removed)
PubB Book Two (e-mail address removed)
PubC One Volume (e-mail address removed)
PubD Another Text (e-mail address removed)
PubE First of Many Books (e-mail address removed)
PubE Second of Many Books (e-mail address removed)
PubE Third of Many Books (e-mail address removed)
PubE Last of Many Books (e-mail address removed)
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 (e-mail address removed) 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