zip question for Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjtjjtjt - 01 Feb 2004 00:36 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 01 Feb 2004 01:51 GMT

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.

Signature

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

> From a thread on the Excel general list:
> This post pertains to formatting difficutlies when importing the zip field
[quoted text clipped - 11 lines]
>
> tj

Reply to this Message

Graham Mayor - 01 Feb 2004 05:55 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> From a thread on the Excel general list:
> This post pertains to formatting difficutlies when importing the zip
[quoted text clipped - 11 lines]
>
> tj

Reply to this Message