[mso] Re: Mail Merge
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 23 Sep 2002 10:12:12 -0400
Looks to me like it's three mail merges....each one filtered by the
Desig field. You still didn't tell me which version of Word you are
using tho, so I can't give you the exact steps....but in the same place
where you sort in a mail merge, theres's an option to filter (in the
last step of the mail merge)....do one merge, filtered on group 1, then
another filtered on group 2, then 3, etc....and each merge can have a
different description typed in.
Or...a "less easy" way is to use field codes....on your maill merge
toolbar there is "insert merge field" and "insert Word field"...use the
Word field one and choose "If...Then...Else..." This is something you
will need to play with...if it gives you problems, Dian is the Fields
expert in here so maybe she can help you...and your actual merge fields
would have to include the descriptive data, so, personally, I would go
with the first suggestion I made and just use three separate merges
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Monday, September 23, 2002 9:03 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Mail Merge
I have a query in Access where there is a field that identifies three
groups
of persons. We are making a telephone/location directory something like
this:
Desig Name Extn Locn
group1 Smith, Jones 8374 DLH
group2 Angel, Rona 7298 MHP
group1 Nauge, Susan 4422 SND
group3 Latel, Sharon 4243 DLH
I would like to do one mail merge in Word so that everyone in Group1 is
alphabetical, then Group2, etc which I could do by sorting. However, I
need
to separate the groups with text describing each group...sort of a
mission
statement for each. The result should look something like this:
Group 1 is responsible for.....
A
listing
B
listing
C
listing
Group 2 is responsible for.....
A
listing
B
listing
C
listing
Group 3 is responsible for.....
A
listing
B
listing
C
listing
*************************************************************
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?Subject=unsubscribe
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:
