Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts
    We currently use MS Office 2003 and are trying to encourage the use of tools such as Mail Merge to speed up some mundane functions within departments.

    Our Finance Team are trying to use Merge to Email using a Excel data source where the email field contains multiple email addresses. The table has been laid out this way as each row of data is unique and may have to be sent to one or more recipients. To keep the table as simple as possible, rather than add in multiple rows of the same information for each recipient we want to send one row of data to multiple people. We have tried entering the email addresses within one cell, separating the addresses with semicolons and commas, surrounding all the addresses and the addresses individually with quotes to no avail..

    The only other way that I have thought this might be possible would be the creation of Distribution Lists, and send to the DL rather that to the addresses individually.. Anyone got any other thoughts on how this can be achieved?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can't enter multiple e-mail addresses in the e-mail field for a mail merge.

    An alternative would be to program the mail merge by automating Outlook from Word, but that would be a lot of work.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans - Thanks for getting bakc to me so quickly. I thought that might be the case, but just wanted to check.

    I now have it working with Distribution Lists - its a bit more cumbersome, but workable, and will certainly save our Finance department many hours of work..

    Thanks Again!

    Alba

Posting Permissions

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