[mso] Re: Word Form IF Statement...Maybe?
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 3 Oct 2003 10:47:45 -0400
trust me Linda. I DON'T have access to the file. All I can see in Word
is the list Insert Merge Fields icon. The Open Data Source and Mail
Merge Recipients icons are grayed out. The only thing I can do is
choose which fields I want to include in a merge, one of which is that
blasted @#$%* communication field. isn't there some way in a merge field
to say 'like' ?
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]=20
Sent: Friday, October 03, 2003 10:46 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word Form IF Statement...Maybe?
<<I don't actually have direct access to the data source and can't do
the filter thing as you suggested.>>
Not true, Glenda...did you actually try what Anne and I suggested? You
don't need "access" to the Excel file...you are not filtering that...you
are filtering the data you now have brought into the Word file....and
you DO have access to that once you've done the merge...reread the steps
both Anne and I gave you...it's really simple if you do it this way
Anne's steps and mine are for Word 2002...but in Word 2000, you can do
it also...once you've completed the merge, go back to the Mail Merge
dialog box and look at the bottom section..there's a button that says
something like "Query options"...it's right beside the merge
button...just use that to choose your Communication field, then choose
"Does not contain" in the next box and type a @ in the third box.=20
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Friday, October 03, 2003 10:25 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word Form IF Statement...Maybe?
I don't actually have direct access to the data source and can't do the
filter thing as you suggested. This data source is on a hosted
internet-based system. The only thing I can do is include the fields in
my merge document. I have no other access or control of the data file.
*************************************************************
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=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
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 with the word "unsubscribe" (without the quotes) in
the subject line.
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:
