 |
 | 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 / October 2005How do I set mail merge field to not appear if blank?
The reason I ask is in Word 2000 it automatically brings the data up when the field is blank. I am sure there must be a way of setting this in Word 2003 but I cannot find it anywhere. I don't want to have to put in IF ASK etc everytime I merge? Thanks! Amber Hi, Amber. This occurs when we use the "address block". Don't use it. Instead, use the individual fields. See: http://www.officearticles.com/word/insert_merge_fields_in_microsoft_word.htm ************ Anne Troy www.OfficeArticles.com > The reason I ask is in Word 2000 it automatically brings the data up when > the [quoted text clipped - 6 lines] > > Amber Thank you! I will give it a try... > Hi, Amber. This occurs when we use the "address block". Don't use it. > Instead, use the individual fields. See: [quoted text clipped - 13 lines] > > > > Amber The person I am helping isn't actually using the address block. They are inserting each field separately and then pressing the merge button to see what it looks like before merging to a file. I checked the Hidden text button and it isn't checked. Any other ideas? Thanks! > Thank you! I will give it a try... > [quoted text clipped - 15 lines] > > > > > > Amber From the Tools menu, select Customise and then go to the Commands tab and select the All Commands category and then scroll down through the list of commands until you find the Mail Merge Helper item. Left click on it and drag it onto a toolbar. Then you will be able to mailmerge as you did in Word 2000  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > The person I am helping isn't actually using the address block. They are > inserting each field separately and then pressing the merge button to see [quoted text clipped - 25 lines] >> > > >> > > Amber Thanks very much Doug, I will do that right now! > From the Tools menu, select Customise and then go to the Commands tab and > select the All Commands category and then scroll down through the list of [quoted text clipped - 31 lines] > >> > > > >> > > Amber This is a really useful tip and I have tried it and it works well. However, all of a sudden it has disappeared from the toolbar and the Mailmerge Helper is no longer in the customise options. I am working on a network using SP2 - it may be that an upgrade has been done but I still can't work out why the option has disappeared and I can't redo it. > From the Tools menu, select Customise and then go to the Commands tab and > select the All Commands category and then scroll down through the list of [quoted text clipped - 31 lines] > >> > > > >> > > Amber I think that you will find that it is still there. Just a matter of looking a bit more carefully. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > This is a really useful tip and I have tried it and it works well. > However, [quoted text clipped - 45 lines] >> >> > > >> >> > > Amber |
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.