Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Mail merge to email problem extracting two email address

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RubenM - 18 Aug 2004 23:55 GMT
I am using Word & Access 2003.

Trying to mailmerge to email using my customers access data base,  using one
access text field that have stored two email address separated by semicolon
got the following check name error:

Microsoft Office does not recognize  email1; email2
The mail is not sent.

Most of my customers have more than one email address and I want to send the
email to each of the email address.  How can I do that?

Thanks for your help
Signature

Ruben

Doug Robbins - 19 Aug 2004 00:41 GMT
The procedure that is used in the macro in the article "Mail Merge to E-mail
with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

can handle multiple email addresses.
Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am using Word & Access 2003.
>
[quoted text clipped - 12 lines]
>
> Thanks for your help
RubenM - 19 Aug 2004 01:57 GMT
Sorry, I am not a programmer.
Why I can´t have a text field containing two email address separated by one
semicolon (for example:  ruben@hotmail.com;  ruben2@hotmail.com) in an access
table, and use that field in a mailmerge to email message and have the mail
produced?,  Do I have to create different fields to keep multiple emails
address for a simple customer record?

> The procedure that is used in the macro in the article "Mail Merge to E-mail
> with Attachments" at
[quoted text clipped - 17 lines]
> >
> > Thanks for your help
Graham Mayor - 19 Aug 2004 07:18 GMT
You don't need any programming skills to use the macro. Doug has done that
for you - see http://www.gmayor.com/installing_macro.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Sorry, I am not a programmer.
> Why I can?t have a text field containing two email address separated
[quoted text clipped - 34 lines]
>>> --
>>> Ruben
Chuck Morrow - 20 Aug 2004 23:35 GMT
In the "Setup" section of this document, instruction is given to create e
"Directory" type merge.  This is to create a list of email address and the
drive/path of the attachment.  The end result is supposed to be a table.
When I did this, it did not create a table.  So I did a single row table and
completed the directory merge and then saed the resultant multi-row table as
"Directory.doc".

The next set of instructions says as follows:  "Then execute the mail merge
that you want to send out by email with attachments and then with the result
of execution of that mail merge on the screen, run a macro containing the
following code.:

What is not clear is what type of mail merge am I supposed to do at this
point?  to Letter or to email?  When I did it to Letter, it generated the
letters but nothing was sent when I did the macro.  When I did email merge,
the original emails were sent but not the attachments.

What am I doing wrong?

Thanks for any help.

Chuck Morrow

> The procedure that is used in the macro in the article "Mail Merge to E-mail
> with Attachments" at
[quoted text clipped - 17 lines]
> >
> > Thanks for your help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.