T
Todd Lemen
I assume the objective here is to create personalized, or
customized, emails without Word's mail merge. It is
possible to define an Outlook.MailItem in VBA (assuming
you're referencing the Outlook object library), then
create the body of the letter using the
MailItems's .Body property. You could loop through your
list, creating customized messages as you go,
accumulating them in Outlook's Outbox, and telling
Outlook to send them every 10th instance or end-of-list,
whichever comes first. No need for Word that way... Is
this what you're after?
TL
customized, emails without Word's mail merge. It is
possible to define an Outlook.MailItem in VBA (assuming
you're referencing the Outlook object library), then
create the body of the letter using the
MailItems's .Body property. You could loop through your
list, creating customized messages as you go,
accumulating them in Outlook's Outbox, and telling
Outlook to send them every 10th instance or end-of-list,
whichever comes first. No need for Word that way... Is
this what you're after?
TL