Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi All,

    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 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
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This is a duplicate of Post 775821. Please don't post the same question in different forums - it will lead to confusion.

    This topic is locked, please post any replies in the other topic.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •