Multiple e-mail addresses in e-mail mail merge

[mfuller]

In attempting tto create an e-mail mail merge, I've been unable to determine
how to allow multiple e-mail addresses. The data is in an Access database;
the column with e-mail addresses has each e-mail address separated with a
semi-colon (also tried as comma-delimited, that didn't work either).

Any suggestions?

 

[Pete D.]

'Resolve each Recipient's name.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve

 

[mfuller]

Okay, really dumb question: where does that code need to go?

 

[Pete D.]

Not a dumb question, dumb response from someone that assumed. Give me a
little more info on how you are doing the merge, macro, vba? If vba post
your code. Are all the email address currently in one field. Use the
semi-colon for outlook which makes one more question, what email program?
Are you doing it from word using access as data source? Sorry for the
incomplete answer. Pete

 

[mfuller]

Pete,

Thanks for another quick response. I'm doing the merge from Access,
exporting the data as a Microsoft Word Merge document. Then using Word to
complete the e-mail merge. All of the e-mail addresses are in one column in
Access, separated by a semi-colon. I tried changing that to a comma [as well
as the setting for Outlook to accept commas to separate e-mail addresses],
but it still didn't work (tried with a semi-colon and a space, semi-colon and
no space, comma and a space, comma and no space). I'm using Access 2003, Word
2003, and Outlook 2003.

Thanks for all your help with this!

 

[Pete D.]

Well that was fun, word merge is looking for each record to be a new email
address. I tested it and it works fine if each record is a single record
from access. I doesn't do multi email addresses in a field unless each is a
new record. The idea being each letter/item is personalized to the
individual. Sorry, you need to rethink what your trying to do. By the
way, my test was so successful I might be blocked for spamming...by
accident. When you get it right, might want to shut down you network
connection before testing...

Pete,

Thanks for another quick response. I'm doing the merge from Access,
exporting the data as a Microsoft Word Merge document. Then using Word to
complete the e-mail merge. All of the e-mail addresses are in one column
in
Access, separated by a semi-colon. I tried changing that to a comma [as
well
as the setting for Outlook to accept commas to separate e-mail addresses],
but it still didn't work (tried with a semi-colon and a space, semi-colon
and
no space, comma and a space, comma and no space). I'm using Access 2003,
Word
2003, and Outlook 2003.

Thanks for all your help with this!

Not a dumb question, dumb response from someone that assumed. Give me a
little more info on how you are doing the merge, macro, vba? If vba post
your code. Are all the email address currently in one field. Use the
semi-colon for outlook which makes one more question, what email program?
Are you doing it from word using access as data source? Sorry for the
incomplete answer. Pete

 

[mfuller]

Pete,

Thanks for all your help with this. I appreciate the time and effort. I'll
work on finding another method to accomplish this e-mail merge.

Well that was fun, word merge is looking for each record to be a new email
address. I tested it and it works fine if each record is a single record
from access. I doesn't do multi email addresses in a field unless each is a
new record. The idea being each letter/item is personalized to the
individual. Sorry, you need to rethink what your trying to do. By the
way, my test was so successful I might be blocked for spamming...by
accident. When you get it right, might want to shut down you network
connection before testing...

Pete,

Thanks for another quick response. I'm doing the merge from Access,
exporting the data as a Microsoft Word Merge document. Then using Word to
complete the e-mail merge. All of the e-mail addresses are in one column
in
Access, separated by a semi-colon. I tried changing that to a comma [as
well
as the setting for Outlook to accept commas to separate e-mail addresses],
but it still didn't work (tried with a semi-colon and a space, semi-colon
and
no space, comma and a space, comma and no space). I'm using Access 2003,
Word
2003, and Outlook 2003.

Thanks for all your help with this!

Not a dumb question, dumb response from someone that assumed. Give me a
little more info on how you are doing the merge, macro, vba? If vba post
your code. Are all the email address currently in one field. Use the
semi-colon for outlook which makes one more question, what email program?
Are you doing it from word using access as data source? Sorry for the
incomplete answer. Pete

Okay, really dumb question: where does that code need to go?

:

'Resolve each Recipient's name.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve

In attempting tto create an e-mail mail merge, I've been unable to
determine
how to allow multiple e-mail addresses. The data is in an Access
database;
the column with e-mail addresses has each e-mail address separated
with
a
semi-colon (also tried as comma-delimited, that didn't work either).

Any suggestions?

 

[Pete D.]

Okay, one suggestion, you might look at doing it all from access with a
report and some VBA. Sounds difficult but with samples folks here can
provide it usually works better than getting multi applications involve. If
you decide to try this repost a new thread as folks may not jump back into
this one. Pete

Pete,

Thanks for all your help with this. I appreciate the time and effort. I'll
work on finding another method to accomplish this e-mail merge.

Well that was fun, word merge is looking for each record to be a new
email
address. I tested it and it works fine if each record is a single
record
from access. I doesn't do multi email addresses in a field unless each
is a
new record. The idea being each letter/item is personalized to the
individual. Sorry, you need to rethink what your trying to do. By the
way, my test was so successful I might be blocked for spamming...by
accident. When you get it right, might want to shut down you network
connection before testing...

Pete,

Thanks for another quick response. I'm doing the merge from Access,
exporting the data as a Microsoft Word Merge document. Then using Word
to
complete the e-mail merge. All of the e-mail addresses are in one
column
in
Access, separated by a semi-colon. I tried changing that to a comma [as
well
as the setting for Outlook to accept commas to separate e-mail
addresses],
but it still didn't work (tried with a semi-colon and a space,
semi-colon
and
no space, comma and a space, comma and no space). I'm using Access
2003,
Word
2003, and Outlook 2003.

Thanks for all your help with this!

:

Not a dumb question, dumb response from someone that assumed. Give me
a
little more info on how you are doing the merge, macro, vba? If vba
post
your code. Are all the email address currently in one field. Use the
semi-colon for outlook which makes one more question, what email
program?
Are you doing it from word using access as data source? Sorry for the
incomplete answer. Pete

Okay, really dumb question: where does that code need to go?

:

'Resolve each Recipient's name.
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve

In attempting tto create an e-mail mail merge, I've been unable
to
determine
how to allow multiple e-mail addresses. The data is in an Access
database;
the column with e-mail addresses has each e-mail address
separated
with
a
semi-colon (also tried as comma-delimited, that didn't work
either).

Any suggestions?