ADDRESS NUMBERS SHOW AS 0 WHEN MAIL MERGING FROM EXCEL

D

DeanH

when i am mail merging from excel i sometimes get 0 where the house number
should be. this does not happen on every number.
 
P

Peter Jamieson

Some questions:
a it sounds as ifyou have a separte house number column. If there is no
house number, does it contain blank? If so, is that when you see "0"? or is
it more arbitrary than that?
b. which version of Word are you using? How are you connecting to Excel? If
you are using Word 2002/3 and check Word Tools|Options|General|"Confirm
conversion at open". go through the connection process again, then select
the DDE option when prompted, do you get the result you need?

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Width of document changes when merging 1
Page numbering with Merged Document and IF statements 1
Merge Excel file into Word Document 3
Mail Merge Directory Conditional Page Break 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail Merge - displaying a conditional number of decimals 5
Duplicate Mail Merge Record Every Time 5

Top