Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Excel data source for mail merge and another question
1. First question - I am using Excel 2003 as the data source for a large mail
merge. My data is sorted in multiple tabs. How do I get the Word document to recognize the various tabs? 2. Second question - Can I suppress lines in a table in Word if there is no correspondng data in the linked Excel spreadsheet? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Excel data source for mail merge and another question
Answer to first question, Word can only use a single flat file as a data
source. Hence all of the data for the mail merge must be on one sheet in the work book. If you question was how do you get to see the various sheets in the work book when attaching the data source so that you can select the appropriate one, from the Tools Menu in Word, select Options and then go to the General tab and check the box for the item "Confirm File Format Conversion on Open" After doing that, when you attach the data source to the mail merge main document, you will be asked for the method by which the attachment should be made and one of the options will show all of the work sheets to allow you to select one of them. Re the second question, this can be done using an If...then...Else field construction such as { IF { MERGEFIELD fieldthatmaybeempty } "" "{ MERGEFIELD fieldthatmaybeempty }¶ { MERGEFIELD nextmergefield }" "{ MERGEFIELD nextmergefield } } You must use Ctrl+F9 to insert each pair of field delimiters and where the ¶ appears in the above, you must press the Enter (or Shift+Enter) key(s). If you have a whole series of fields that may be empty, you need to use a construction such as the following, which is really all contained within the one paragraph 2008-2009 Base Salarv ${ MERGEFIELD Facctrct_Base_Pay }{ IF { MERGEFIELD Facctrct_Merit_Pay } 0 "¶ Merit ${ MERGEFIELD Facctrct_Merit_Pay }" "" }{ IF { MERGEFIELD Facctrct_Dana_Pay } 0 "¶ Dana Professorship ${ MERGEFIELD Facctrct_Dana_Pay }" "" }{ IF { MERGEFIELD Facctrct_Promo_Pay } 0 "¶ Promotion ${ MERGEFIELD Facctrct Promo_Pay }" "" }{ IF (MERGEFIELD Facctrct_Adj_Pay} 0 "¶ Adjustment ${ MERGEFIELD Facctrct_Adj_Pay }" "" }{ IF { MERGEFIELD Facctrct_Other_Pay } 0 "¶ Other ${ MERGEFIELD Facctrct_Other_Pay }" "" } -- Hope 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, originally posted via msnews.microsoft.com "Valerie" wrote in message ... 1. First question - I am using Excel 2003 as the data source for a large merge. My data is sorted in multiple tabs. How do I get the Word document to recognize the various tabs? 2. Second question - Can I suppress lines in a table in Word if there is no correspondng data in the linked Excel spreadsheet? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Excel data source | Mailmerge | |||
mail merge with excel data source | Microsoft Word Help | |||
mail merge from excel data source | Mailmerge | |||
Mail Merge from Excel data source | Microsoft Word Help | |||
Mail Merge using an Excel spreadsheet as a data source | Microsoft Word Help |