[mso] Re: Excel or ???
- From: Linda Johnson <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 09 May 2002 12:43:14 -0400
Put it in Excel, then use the excel file as your data source when you
create a mail merge in Word.....make sure the Excel file has headings at
the tops of the columns, then these will show up as your field names
when you to the mail merge...all you need to do is put the First Name
field where you want it to appear in the form letter and a first name
will appear for each person, one per letter....then add envelopes to the
same merge and you will print an envelope for each where you can put
First Name, Last Name, and Address fields
Unless I am totally misunderstanding what you want to do....don't know
what you mean when you say you want to send one mail to "combined"? Are
you talking email??
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
www.personal-computer-tutor.com
Author/Teacher ~ MS Office EBooks/Classes
www.personal-computer-tutor.com/services.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Thursday, May 09, 2002 9:26 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Excel or ???
I have a list that can be in Excel or Access or Word or wherever????
The list consists of several fields
EXAMPLE
Last First Combined
Address
Smith John Mr & Mrs John Smith 123
Someplace, Anywhere AK 56789
Smith Andrea Mr & Mrs John Smith 123 Someplace,
Anywhere AK 56789
Jones Martin Mr & Mrs Martin Jones 456 Nowhere,
There
WA 78956
Jones Martha Mr & Mrs Martha Jones 456 Nowhere,
There
WA 78956
In a mailing, I just want to send one letter to Combined but in the mail
piece I need each of their First names.
What's the best way to do this?
I know I could do something with Uniques in Access which will give me a
list
of Combined with Address but then how do I keep the paperwork in order
so
the mail pieces get into the right envelopes?
Right now, the people who do these mailings (and it's hundreds of
letters
per day) are manually picking out the "duplicates", creating a waste of
printed mail pieces and envelopes and wasting a huge amount of time.
HELP!!!
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
