General discussion

  • Creator
    Topic
  • #2285345

    Mail Merge using Excel Data

    Locked

    by mdbiggar ·

    I have an excel spreadsheet that lists all of my contractors. Many have multiple e-mail addresses. When I try to do a mail merge in Word to an e-mail using the excel sheet as a data source, it ignores the rows that have multiple e-mail addresses listed. I have tried separating the data in the spreadsheet using semi colons, colons, commas, etc. and this does not work. Is there any way to format the data so that word will not ignore it and hopefully send to all email addresses without making each unique e-mail address a separate row within the excel document. This work around will render the spreadsheet useless for my other tasks. I am using Office 2002. Help please!

All Comments

  • Author
    Replies
    • #2517653

      Same problem…

      by jeff.herrick ·

      In reply to Mail Merge using Excel Data

      We recently switched from Novell to Outlook, and I was hoping this issue would be resolved, but I am having the same issues you are having, and cannot find a absolute solotion.

      Can anybody help?

    • #2517604

      create

      by sue t ·

      In reply to Mail Merge using Excel Data

      This isn’t perfect but may work for what you want to do. Create a 2nd worksheet and link to the original worksheet only the fields you want to use for your mail merge. that way the information you need would be automatically inserted into the fields you specify on the new worksheet and you could then use that new worksheet for your mail merge as the extra email addresses would not be there. This would also keep your original the way you need it for your other tasks.

Viewing 1 reply thread