zip question for Mail Merge

[tjtjjtjt]

From a thread on the Excel general list
This post pertains to formatting difficutlies when importing the zip field from an Excel spreadsheet that's using the zip format

Dave Peterson wrote

After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Exce
Worksheets via DDE (*.xls)', and your formatting will be retained

I'm not getting any dialogue boxes where I can choose this option when I choose an Excel sheet as my source. It sounds like something I can make good use of. Dave, anyone else: what I'm I missing

tj

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Select Options from the Tools menu in Word and then go to the General tab
and check the "Confirm conversions at open" box and you will then be given
a choice.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Graham Mayor]

You may find http://www.gmayor.com/formatting_word_fields.htm and the page
it links to useful.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>