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
