personalize messages during e-mail merge

M

Mike

Hi All,
I am using Office 2003 and while performing an e-mail merge I am not offered
the option to "edit individual messages" at step 6 of 6 as you are when
performing a mail or label merge. I would like to be able to personalize my
e-mails beyond the capability of any merge fields. Can anyone assist?
 
D

Doug Robbins - Word MVP

Execute the merge to a New Document and then you will get a new document
that contains each of the messages. Edit each one as required, and then
use the method in the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm to send each
message.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
M

Mike

I must have mis-spoke. I desire to access each of my e-mails messages
individually and add a personal message such as "Happy Birthday", "Get Well
Soon", "See You There", etc. Not all messages will have a personal note
every time (monthly). The site you directed me to assumes all messages get
the same comment or requires me to generate a seperate message for each
occasion/event (if I read it correctly). Exactly what I wanted to avoid. Oh
yes, I am initiating the merge from Access. Hope I'm expressing my needs
clearly.
--
Thanks,

Mike


Doug Robbins - Word MVP said:
Execute the merge to a New Document and then you will get a new document
that contains each of the messages. Edit each one as required, and then
use the method in the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm to send each
message.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
M

Mike

I may have spoken too soon. Will try your suggestion removing all the
references to attachments. I assume you have to go to Tools/Macro/Macros to
run it? If you have a better solution I would really like to hear it.
--
Thanks,

Mike


Doug Robbins - Word MVP said:
Execute the merge to a New Document and then you will get a new document
that contains each of the messages. Edit each one as required, and then
use the method in the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm to send each
message.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
G

Graham Mayor

You can use conditional fields to add personal notes eg

{IF {Mergefield Name} = "Fred" "How about that game of golf next week?"}{IF
{Mergefield Name} = "John" "Give me a call when you are free"} etc.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
R

Rich/rerat

Mike,
I don't know exactly what you mean by, "...to personalize my
e-mails beyond the capability of any merge fields."

But I would think that you could add another field in your data source, such
as "PS Line". And before starting the merge, open the data source, and edit
this column with your comment or phrase, close and save changes. Then start
the mailmerge, I believe you will need to limit the phrase to less than 255
characters and spaces, though.

So you would Insert {mergefield PS_Line}, at the end of your message.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


Hi All,
I am using Office 2003 and while performing an e-mail merge I am not offered
the option to "edit individual messages" at step 6 of 6 as you are when
performing a mail or label merge. I would like to be able to personalize my
e-mails beyond the capability of any merge fields. Can anyone assist?
 
P

Peter Jamieson

Another thing you could try is
a. work out how to switch off Sending in outlook (presumably 2003)
b. before your merge, switch off sending
c. do the merge. The messages will appear in the Outbox
d. Open each message, personalise as required, re-Send
e. switch on Sending again
 
M

Mike

Thanks Peter this is the method I prefer.
--
Thanks Again,

Mike


Peter Jamieson said:
Another thing you could try is
a. work out how to switch off Sending in outlook (presumably 2003)
b. before your merge, switch off sending
c. do the merge. The messages will appear in the Outbox
d. Open each message, personalise as required, re-Send
e. switch on Sending again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top