Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jenny hall Jenny hall is offline
external usenet poster
 
Posts: 2
Default make mailmerge leave blanks when fields are empty

Mailmerge kindly moves fields together when there are blanks (like in a short
address). Does anyone know how to stop this so the balnks are retained?

Also, does anyone know how to ensure that a field defined in Excel as text,
but containing mainly numbers, is treated by Word as text. At the moment, it
seems to treat this data as numeric, and represents any fields containing
non-numerics as 0. Only way round this at the moment is to ensure that the
first entry contains a non-numeric.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default make mailmerge leave blanks when fields are empty

Jenny hall wrote:
Mailmerge kindly moves fields together when there are blanks (like in
a short address). Does anyone know how to stop this so the balnks
are retained?


Use a conditional field eg

{IF {Mergefield fieldname} "" "{Mergefield fieldname}" " " }

Also, does anyone know how to ensure that a field defined in Excel as
text, but containing mainly numbers, is treated by Word as text. At
the moment, it seems to treat this data as numeric, and represents
any fields containing non-numerics as 0. Only way round this at the
moment is to ensure that the first entry contains a non-numeric.


You could try:

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

or use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jenny hall Jenny hall is offline
external usenet poster
 
Posts: 2
Default make mailmerge leave blanks when fields are empty

Thanks for the reply - I notice a number of posts now about
including/suppressing lines, so it's clearly an issue. In the end, we
re-defined the template using a table, as this was easier. The user also
included a dummy record with alpha characters to resolve the second issue - I
had tried applying a text format to the field, but it still didn't work and
we are trying to keep it simple. However, I really appreciated your
suggestions.

"Graham Mayor" wrote:

Jenny hall wrote:
Mailmerge kindly moves fields together when there are blanks (like in
a short address). Does anyone know how to stop this so the balnks
are retained?


Use a conditional field eg

{IF {Mergefield fieldname} "" "{Mergefield fieldname}" " " }

Also, does anyone know how to ensure that a field defined in Excel as
text, but containing mainly numbers, is treated by Word as text. At
the moment, it seems to treat this data as numeric, and represents
any fields containing non-numerics as 0. Only way round this at the
moment is to ensure that the first entry contains a non-numeric.


You could try:

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button Word Options Advanced General Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

or use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form: Leaving Empty Fields Empty Rosiewednesday Microsoft Word Help 3 June 11th 08 09:27 AM
Print Recordset Leave Blanks Ripper Mailmerge 2 February 27th 08 08:54 PM
Make word leave spaces when fields are blank Not_A_Real_Programmer Mailmerge 2 October 4th 07 05:32 PM
Mailmerge:unwanted blank lines caused by empty data fields Mail merge - Empty data field Microsoft Word Help 0 October 5th 05 01:09 PM
mail merge some fields leave other as form fields BethW Mailmerge 1 September 20th 05 06:47 PM


All times are GMT +1. The time now is 08:11 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"