Directory Mail Merge and Email to recipients from Spreadsheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top