Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2016, 06:49 AM
Shazz Shazz is offline 0 showing in address when mail merging Windows 7 64bit 0 showing in address when mail merging Office 2010 64bit
Novice
0 showing in address when mail merging
 
Join Date: May 2012
Posts: 10
Shazz is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-10-2016, 08:45 PM
macropod's Avatar
macropod macropod is offline 0 showing in address when mail merging Windows 7 64bit 0 showing in address when mail merging Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 03-11-2016, 01:54 AM
Shazz Shazz is offline 0 showing in address when mail merging Windows 7 64bit 0 showing in address when mail merging Office 2010 64bit
Novice
0 showing in address when mail merging
 
Join Date: May 2012
Posts: 10
Shazz is on a distinguished road
Default

Thanks Paul, that worked a treat.

Shazz
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
0 showing in address when mail merging 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
0 showing in address when mail merging 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
0 showing in address when mail merging 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft