[mso] Re: Mail Merge
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Mon, 23 Sep 2002 09:03:12 -0400
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
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Monday, September 23, 2002 8:54 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Mail Merge
Glenda....since James's reply is not what you are looking for, I need you to
re-state your original question since I'm not understanding what you want.
Are these "groups" in fields? When you do the mail merge from Word, have
you tried using MS Query inside the mail merge to "filter" the merge?
I don't know Access very well, but I DO know Word mail merges VERY well, so
if you let me know more of the specifics, I can let you know if and how to
do what you want from within the merge.
Also....what version of Word are you using to do this, cuz mail merges are
very different in Word 2002 than they are in 2000 or 97.
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 8:43 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Mail Merge
Thanks James. That's the Access way. I was hoping to use MS Word/Mail Merge
for this task as it's someone else's responsibility and they don't know
Access and they will want to modify fields and data from time to time which
they could easily do via Word or even Excel. Oh well, guess I'll have to
have another class for the basics. Thanks again. /gl
-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]
Sent: Friday, September 20, 2002 5:08 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Mail Merge
Glenda,
Are you working in Access and want to create a phone/email directory? If so
your best bet is to create a group field and assign each user to the group
desired. Then when you create your directory group on the directory. You
can put a page break in the group footer if you like although it will give
you a blank page at the end of your document. This way, each group is in
its own section and separated onto its own page(s).
Hope This is what you wanted.
James La Borde
South Western Federal Credit Union
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Friday, September 20, 2002 10:52 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Mail Merge :VSMail MX1
I am trying to create a directory that holds 3 groups.
I have the groups in one query in Access.
I want to include all three groups in the directory but I want them in
different sections. What's the best way to do that?
Thanks.
*************************************************************
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:
