Unique Subject Line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HotSauce - 30 Oct 2004 17:00 GMT

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?

Signature

Roger Smith, CISSP
SOX Internal IT Auditor/Consultant

Reply to this Message

Cindy M -WordMVP- - 01 Nov 2004 20:13 GMT

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
[quoted text clipped - 5 lines]
> 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 :-)

Reply to this Message

Doug Robbins - 02 Nov 2004 01:00 GMT

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

Signature

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

> Hi
>
[quoted text clipped - 8 lines]
> Is there any way to coerce mailmerge into creating a unique (merge
> generated) subject line for each outgoing email?

Reply to this Message

HotSauce - 06 Nov 2004 19:42 GMT

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:
>
[quoted text clipped - 14 lines]
> > Is there any way to coerce mailmerge into creating a unique (merge
> > generated) subject line for each outgoing email?

Reply to this Message

Sam - 20 Jan 2005 06:59 GMT

Hey HotSauce,

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

> Hi Doug
>
[quoted text clipped - 31 lines]
> > > Is there any way to coerce mailmerge into creating a unique (merge
> > > generated) subject line for each outgoing email?

Reply to this Message