To be honest with you...I don't know how to use the Boolean logic in mail merge cos' I would naturally do whatever I need through the use of Access/ADO. Sorry...but I would write a VBA routine to pull whatever I needed from the DB and then use those results. I'm really sad with mail merge, otherwise. Cindy Meister is the Word MVP who we consider the mail merge Queen (I'm the forms/documentation princess<g>). Glenda have you checked out Cindy's site? http://homepage.swissonline.ch/cindymeister/ How about this article from the MVP site? Making your mail merge "intelligent" by using IF fields http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm Sorry...that's the best I can do...I'd have to read it all myself to tell you any more and I've got to go read about Outlook without Exchange now! ;-) Dian D. Chapman Technical Consultant, Microsoft MVP & Instructor Free Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson Sent: Sunday, October 05, 2003 11:49 AM To: mso@xxxxxxxxxxxxx Subject: [mso] TechTrax and Dian's busy-ness (was Word Form IF Statement...Maybe?) I just got it too....see who has the cover article this month? LOL Maybe she'll catch this one since I changed the subject line Dian...do you have a clue how Glenda can get this NextIF or whatever field to pull only records from a mail merge that have a phone number (instead of an email address) in a particular field? Obviously, the unique thing about these fields would be that they do NOT have a @ in them 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 Ray Blake Sent: Sunday, October 05, 2003 12:32 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Word Form IF Statement...Maybe? Well, since I just got the October issue of Techtrax delivered to my mailbox, maybe she'll now have a few minutes to put us all right... Ray ************************************************************* 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 ************************************************************* ************************************************************* 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 *************************************************************