[mso] Re: Word Form IF Statement...Maybe?
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 3 Oct 2003 10:46:19 -0400
<<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.
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
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:
