AboutJean Mornard Expertise I am happy to answer questions about formatting and layout, mail merge, tables, graphics, tracking changes, outlining, and more. I currently use Word 2007, but I can also answer many questions about Word 2003.
Experience I have worked professionally on MS Word since 1992 when v2.0 was launched. For one employer, I created several macros to address the issues of translating a document from a Sun-based desktop publisher to Word and then from Word to ASCII (a VERY specific application). I have created mail merge letters and labels, fliers and brochures, concert programs, investment company documents, large running tables, along with the more ordinary word processing documents.
Education/Credentials B.A from the University of Minnesota
Participated in several work-required training sessions on the entire MS Office Suite, the latest being on the transition between Office 2003 and Office 2007. I have also conducted training sessions on Word and Excel within my work setting.
Question I have a paragraph in a new client welcome letter. It pulls three names separated by a ,(comma) assuming there is a Store Manager,Supervisor,and Director. In some cases there is no supervisor just a Manager and Director. I am pulling from an excel file into word. How go I avoid the empty field from showing and close up the gap?
For example, Please do not hesitate to contact your Manager [manager's name], Supervisor [supervisor's name], and Director [Director's name], if you need additional help.
Thanks Im stumped!
Answer Hi Jayne,
You could use an If...Then...Else statement for the supervisor. It should look something like this:
Please do not hesitate to contact your Manager, { MERGEFIELD Store_Manager }{IF { MERGEFIELD Supervisor } <> "" ", Supervisor { MERGEFIELD Supervisor }, and Director { MERGEFIELD Director }," " and Director { MERGEFIELD Director },"} if you need additional help.
These aren't real fields, obviously. You can generate the If...Then...Else statement using the Rules button on the Mailings tab. I hope this helps!
About Microsoft Word
This topic answers questions related to Microsoft Word stand-alone or Mircrosoft Office Word including Word 2003, Word 2007, Office 2000, and Office XP. You can get Word help on formatting text, tables, tabs, fonts, styles, general Word layouts, bullets, headings, and outlines, using templates, toolbar modifications, and using Track Changes. You may also find tips on linking Word and Excel embedded objects including charts. This site does not provide a general Word tutorial nor the basics of using a word processor. It provides specific answers to using Microsoft Word only. If you do not see your Word question answered in this area then please ask a Word question here
