Mailmerge with multiple emails in single cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bethw - 27 Apr 2006 16:51 GMT

I have a database that includes a contact person for each account. There are
a few of the accounts that have multiple contacts, and I have put their
emails in the same cell, separated by a semi-colon. When I do a mailmerge in
word, it does not recognize these email addresses and will not send the email.
Is there a work around that will allow me to have multiple email addresses
in a single cell and still be able to do a mailmerge?

Reply to this Message

Doug Robbins - Word MVP - 27 Apr 2006 21:32 GMT

The only way to do it would be by using a macro that makes use of the
Outlook Object Model. The macro in the article at:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

has some of the code that you would need to use.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a database that includes a contact person for each account. There
>are
[quoted text clipped - 5 lines]
> Is there a work around that will allow me to have multiple email addresses
> in a single cell and still be able to do a mailmerge?

Reply to this Message

bethw - 28 Apr 2006 00:28 GMT

I am not familiar with running code. How would I go about doing that?

> The only way to do it would be by using a macro that makes use of the
> Outlook Object Model. The macro in the article at:
[quoted text clipped - 11 lines]
> > Is there a work around that will allow me to have multiple email addresses
> > in a single cell and still be able to do a mailmerge?

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2006 05:03 GMT

There's three options:

1. Don't use code and do it manually

2. Become familiar - See the article "Getting To Grips With VBA Basics In
15 Minutes" at:
http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

3. Have someone else create the code for you.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am not familiar with running code. How would I go about doing that?
>
[quoted text clipped - 16 lines]
>> > addresses
>> > in a single cell and still be able to do a mailmerge?

Reply to this Message