Mail Merge dymanic subject line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrea Pala - 26 Feb 2004 19:01 GMT

Help please!
I'm trying to send a mail merge from Word, but I want each
message to have a subject line that differs based on the
user's order number. Is this possible?
Fields:
name, order#, email address

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 27 Feb 2004 03:42 GMT

You would need to use a macro for this. You can probably modify that in the
article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> Help please!
> I'm trying to send a mail merge from Word, but I want each
> message to have a subject line that differs based on the
> user's order number. Is this possible?
> Fields:
> name, order#, email address

Reply to this Message

Peter Jamieson - 27 Feb 2004 08:07 GMT

There is no easy built-in method. If it is Word 2002 or 2003, you should be
able to use the Mailmerge events in Word VBA to modify the subject for each
item. But it isn't particularly simple. Ask if you want further details.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

Reply to this Message