[mso] Re: Outlook - mail merge problem in email
- From: "Ian and Anita Elliott" <ian_and_anita@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 27 Jul 2004 17:38:46 +0530
Hi Karen,
I follow the same steps as when mail merging a word file and use a data file
in excel. Use the headers to identify firstname surname email etc and if
required para1 para2 closing para. Make the individual paragraphs in the
cells within the excel file and then close that file. In word Choose email
as the merge option and then follow the instructions - link the data file
with the word file (use existing file) and then you will be able to preview
the emails in your word file - click on the mailmerge to email button to
send the mails to outlook. Make sure that Outlook is set as the default
email programme and also that it is open when you do the mail merge in word.
It should then line all the emails in your outbox. To add the data fields
such as para1, para2 closing para etc you will need to add these from the
'more items' list which will show all the headers from the data file.
If you wish to take contact information from Outlook to use in the data file
then you can export them from contacts to an excel file. It is very flexible
because you can opt by selection to send to individual people within that
data file. Bear in mind that you might want to make changes to the data file
before doing the mail merge in word especially if you are making some
individual paragraphs.
I have found that this is easier than merging from an Outlook Contacts file
and it also gives me the flexibility to add personalized paragraphs in my
message too.
Regards
Ian Elliott
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Linda F. Johnson
Sent: 27 July 2004 17:23
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Outlook - mail merge problem in email
I have no idea why it is trying to print instead of sending email...that's a
new one, unless you are telling it to do that. By default, mail merges DO
print (since that's what they are usually used for)...make sure you are
choosing email messages in the FIRST step of your merge
However, I do know you cannot merge to a distribution list if you want each
person to get a personalized mail...to do this, you must create a separate
contacts folder for these people, then put all of the names in that folder
(not in a distribution list), then choose that folder to merge to.
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Karen Lubrecht
Sent: Tuesday, July 27, 2004 6:50 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Outlook - mail merge problem in email
I use distribution lists and would occasionally like to personalize the
message for the individual. Is it possible to mail merge into email?
Using Outlook 2002, my contact names. All goes well until it is to sent
the merged mail by email. I have chosen email in the mail merge options,
but it keeps sending me to word and then trying to print! "Help" isn't
showing a solution unless I'm asking the wrong question
TIA!
Karen
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.727 / Virus Database: 482 - Release Date: 26/07/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.727 / Virus Database: 482 - Release Date: 26/07/2004
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
