By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Mail merge to email

P: n/a
I am performing a mail merge and generating e-mails automatically from an
Access Table. When I click the "Merge to Email" icon in Word, the resulting
dialog box only allows me to select one field from my Access table in the
"To:" field. I have 2 fields in my Access table that I need to send an
e-mail to. Is there any VB code that can perform the Mail Merge to e-mail
that is perhaps more flexible than the standard functionality?
Jun 13 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 12 Jun 2007 20:30:28 -0400, "Bill Millerd"
<bm******@rochester.rr.comwrote:

Or you could replace your table by a query that concatenates the
several To values with semicolons in between.
http://www.mvps.org/access/modules/mdl0008.htm may help with this.

-Tom.

>I am performing a mail merge and generating e-mails automatically from an
Access Table. When I click the "Merge to Email" icon in Word, the resulting
dialog box only allows me to select one field from my Access table in the
"To:" field. I have 2 fields in my Access table that I need to send an
e-mail to. Is there any VB code that can perform the Mail Merge to e-mail
that is perhaps more flexible than the standard functionality?
Jun 13 '07 #2

P: n/a
I tried that trick, however, Outlook won't recognize it as 2 separate e-mail
addresses, even if I use the semicolon to separate the two fields. Instead
it tries to read the whole concatenated string as one e-mail address. Any
idea if Outlook is looking for a special formatting on the concatenated
address so that it will recognize as 2 different addresses?
"Tom van Stiphout" <no*************@cox.netwrote in message
news:v4********************************@4ax.com...
On Tue, 12 Jun 2007 20:30:28 -0400, "Bill Millerd"
<bm******@rochester.rr.comwrote:

Or you could replace your table by a query that concatenates the
several To values with semicolons in between.
http://www.mvps.org/access/modules/mdl0008.htm may help with this.

-Tom.

>>I am performing a mail merge and generating e-mails automatically from an
Access Table. When I click the "Merge to Email" icon in Word, the
resulting
dialog box only allows me to select one field from my Access table in the
"To:" field. I have 2 fields in my Access table that I need to send an
e-mail to. Is there any VB code that can perform the Mail Merge to e-mail
that is perhaps more flexible than the standard functionality?

Jun 14 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.