[mso] Re: More on my use of Outlook to send groups of emails

I don't have Outlook at home so I will try to do this by memory:
With your contact file open, choose File-Export - there are various steps to
follow but in the end you end up with an Excel spreadsheet with all of your
contacts listed in rows and the various fields across the top, each a column
head.

Save and close that file.

Now go into Word and set up your document.

Using mailmerge, identify the source of your data (the spreadsheet you just
saved.)

Then line by line you will insert insert each mergefield (name, address,
phone, etc.)  Before each  merge field, type out the name of the field.  So
the end result will be:

Name:  John Doe
Address: 123 Main
Phone: 123-1234
E-mail: whatever@xxxxxxx
etc.

After you've set up your document, you then "Preview results" to make sure
it looks the way you want it.  Then, "complete the merge" and choose e-mail
option.

Then watch it go!

I've modified and attached the two files I used to produce my merge to
e-mail.  There is a spreadsheet with 10 records and the mail merge
letter.   (the mailmerge I did resulted in 700 personalized e-mails.)

While my spreadsheet has fewer fields than yours will, you will hopefully
get the idea.

Good luck!

Jean T





On Fri, Jul 4, 2008 at 11:50 PM, James S. Huggins (mso) <
MicrosoftOffice@xxxxxxxxx> wrote:

>
> ==========================
> I did  almost the identical application just this past week.
> Essentially what I did was to export my information from my database (not
> Outlook) to a spreadsheet and then ran a mail merge to e-mail.   Worked
> like
> a charm!
>
> You could do the same thing only your data would come from your Outlook
> contacts.
> ==========================
>
> I'm interested in more of the specifics.
>
> I want the mail merge to include not just email address, but names,
> multiple
> phone numbers, notes ... the whole schebang.
>
> In effect, in the max case, I'd like to email everyone in Outlook with a
> full dump of everything I have about them in Outlook an ask: Is it right?
>
> I'd appreciate all guides, particularly a detained step-by-step one with
> examples.
>
>
>
> James S. Huggins
>        writing you from "Dallas"
>        with Spot (my cat) sitting at my elbow
>
>
> ...
>
> *************************************************************
> 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, visit the group's homepage and use the
> dropdown menu at the top.  This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group.  This group will not allow for posting of emails, but will allow you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>



-- 
Jean Tredinnick
3 Watch Tower Lane
Old Greenwich, CT 06870
203.698.2349



-- No attachments (even text) are allowed --
-- Type: application/msword
-- File: Directory_letter_07-08_Final_to_HOH_or_spouse_with_e-mail_.doc


-- No attachments (even text) are allowed --
-- Type: application/vnd.ms-excel
-- File: Directory_letter_-_spouse_with_e-mail.xls


*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: