Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge with multiple emails in single cell
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge with multiple emails in single cell
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/...ttachments.htm has some of the code that you would need to use. -- 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 "bethw" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge with multiple emails in single cell
I am not familiar with running code. How would I go about doing that?
"Doug Robbins - Word MVP" wrote: 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/...ttachments.htm has some of the code that you would need to use. -- 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 "bethw" wrote in message ... 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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge with multiple emails in single cell
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/Macros...csIn15Mins.htm 3. Have someone else create the code for you. -- 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 "bethw" wrote in message ... I am not familiar with running code. How would I go about doing that? "Doug Robbins - Word MVP" wrote: 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/...ttachments.htm has some of the code that you would need to use. -- 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 "bethw" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any way to copy two paragraphs from one cell to multiple cells? | Tables | |||
How do I e-mail merge to multiple addresses in a single cell? | Mailmerge | |||
How to display multiple docs in a single word window? | Microsoft Word Help | |||
Accurately moving single cell tables | Tables | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge |