#1
|
|||
|
|||
0 showing in address when mail merging
I am hoping someone can help, I am doing a Mail Merge into word from Excel, becasue in excel the address1 field is emplty, word is showing a 0 on that line.
Can anyone advise me how to get rid of it please. Much appreciated Shazz xx |
#2
|
||||
|
||||
Presumably, that field holds just numbers. In that case:
1. select the mergefield 2. press Shift-F9 to expose the field code, which should look like { MERGEFIELD address1 } 3. add a numeric picture switch to the field, thus - { MERGEFIELD address1 \# 0;; } 4. press F9 to update the field 5. Run your mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Paul, that worked a treat.
Shazz |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging, but not with mail | ksims3 | Word | 1 | 07-29-2014 08:27 PM |
How would you go about mail merging this set of data | willsonfang | Mail Merge | 1 | 09-29-2013 07:16 PM |
How to forward all e-mails from one address to five (5) other e-mail address? | adi2012 | Outlook | 1 | 09-09-2012 06:41 PM |
Gaps in address mail merging | Trixz_D | Mail Merge | 2 | 08-05-2012 04:23 AM |
Two Contacts, Same Address! Mail merging married contacts?!! | tomtomlo | Outlook | 0 | 03-26-2008 03:21 PM |