[mso] Re: Mail Merge
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Mon, 23 Sep 2002 10:18:42 -0400
Thanks. I'm Using XP but others who will do this are using 2000.
By doing 3 merges, are you saying I must have 3 merge documents? Or the
result will be 3 merged documents which I will than need to combine to get
my result?
I didn't think of the field codes thing but that might work since there are
so few fields. Hmmmmm.....
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Monday, September 23, 2002 10:12 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Mail Merge
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
*************************************************************
*************************************************************
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:
