 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2004Another If..Then...Else
Merging Labels in Office 2000. The label contain First2, Last2. If there is no First2 then the next record should be accessed, otherwise it should print the label. Now we are getting blank labels if there is no First2. We have filtered the Excel data list and done a separate merge. How do I word the If..Then..Else so it is not necessary to perform this extra step? Thanks for any help you can provide Hi Peggy, > Merging Labels in Office 2000. The label contain First2, Last2. If > there is no First2 then the next record should be accessed, otherwise it > should print the label. Now we are getting blank labels if there is no > First2. We have filtered the Excel data list and done a separate merge. May we assume you've filtered the Excel list to not show records where First2 is empty? In this case, you should now - go to Word's Query Options (You'll see this button in the mail merge Helper or the dialog box you get when you click the Mail Merge... button in the toolbar) - select the First2 field from the list and set it to "Not blank" Now Word should filter out those blank records. (Note that you could do this in Word without first filtering the Excel recordset) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Thank you. I was making it way too difficult. My user did not want to filter Excel first and, of course, the query options in the Merge dialog box does what is needed. Cindy M -WordMVP- wrote: > Hi Peggy, > [quoted text clipped - 21 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.