Why does Word mailmerge drop addresses with dashes?

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

When merging data with dashes (123-A) from Excel 2003 into Word 2003 address
labels, the result is just a "0". Any suggestions?

Thanks
 
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.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
You must log in or register to reply here.

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

Neither an EM Dash or EN Dash, but I need to replace it with a Hyp 2
MSWord mail merge 0
Displaying zeros in cells 2
En and Em Dashes 7
em dash and orphan quotes 9
Word 2003 - Mailmerge 2
Problem with hyphen being replaced 3
Formatting a Single Field in MailMerge word 07 1

Back
Top