Mail merge to email

[Bill Millerd]

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?

[Tom van Stiphout]

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?

[Bill Millerd]

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?