Unique Subject Line

[HotSauce]

Hi

I have a mailmerge that I frequently use to send out 40-60 customized
emails. The merge consists of a common page plus a unique merge generated
attachment. In many cases more than one of these emails will go to the same
person, meaning that the common subject line generated by mailmerge causes
confusion. As a result people often think I have mistakenly sent out
duplicates, however each attachment is very unique.

Is there any way to coerce mailmerge into creating a unique (merge
generated) subject line for each outgoing email?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SG90U2F1Y2U=?=,

Unfortunately, no version of Word supports this. It would require a macro
solution: merge to a document, then split the document up and setting each
record's result up as an email, changing the subject line and attaching the
file. You should find a macro for the latter on the word.mvps.org site; you
can modify it to add the Subject information.

I have a mailmerge that I frequently use to send out 40-60 customized
emails. The merge consists of a common page plus a unique merge generated
attachment. In many cases more than one of these emails will go to the same
person, meaning that the common subject line generated by mailmerge causes
confusion. As a result people often think I have mistakenly sent out
duplicates, however each attachment is very unique.

Is there any way to coerce mailmerge into creating a unique (merge
generated) subject line for each outgoing email?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Doug Robbins]

Here's a link to the article to which Cindy referred you:

"Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm


--
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

 

[HotSauce]

Hi Doug

Thanks much for the link. I downloaded it, and another macro that saves each
letter in a seperate file, earlier this week and was able to accomoplish what
I needed with about a 4 hour investment in programming. A very worthwhile
investment considering the alternative of sending out the email by hand is at
least a 6 to 8 hour timeline.

I have one other question... Is there a way to set the "ReplyTo:" field of
the outgoing emails? I have searched the object browser without much success.
I found a few fields with "reply" in them, but they were either readonly or
they did nothing when I tried to set them.

Thanks again

Roger Smith, CISSP

Here's a link to the article to which Cindy referred you:

"Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm


--
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

 

[Sam]

Hey HotSauce,

Please post a sample of your code. I'm interested how you did it. Thanks
in advance.

Hi Doug

Thanks much for the link. I downloaded it, and another macro that saves each
letter in a seperate file, earlier this week and was able to accomoplish what
I needed with about a 4 hour investment in programming. A very worthwhile
investment considering the alternative of sending out the email by hand is at
least a 6 to 8 hour timeline.

I have one other question... Is there a way to set the "ReplyTo:" field of
the outgoing emails? I have searched the object browser without much success.
I found a few fields with "reply" in them, but they were either readonly or
they did nothing when I tried to set them.

Thanks again

Roger Smith, CISSP