Re: Why is formating (zip & phone) lost when merging from Excel to Wo.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Stefan64" <Stefan64@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74C94F4F-3BC7-435B-9219-761FE980274D@xxxxxxxxxxxxxxxx
> When using office 2003, I want to merge my data from Excel to Word
> (labels,
> letters, etc.) and the formatting for the zip code and telephone # is
> lost.
> Example - in Excel the zip code is 06051 but when merged it is 6051, and
> the
> phone # in Excel is (###) ###-#### and when merged is ##########.
> how can this be resolved???


.

Relevant Pages

  • Re: Trailing zeros cut off on mail merge from Excel
    ... See "Formatting Word fields with switches" on fellow MVP Graham Mayor's ... Please respond to the Newsgroup for the benefit of others who may be interested. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: mail merge wizard
    ... See "Formatting Word fields with switches" on fellow MVP Graham Mayor's ... Please reply to the newsgroup unless you wish to avail yourself of my ...
    (microsoft.public.word.docmanagement)
  • Re: I need a mail merge expert for one question.
    ... See "Formatting Word fields with switches" on fellow MVP Graham Mayor's ... Please reply to the newsgroup unless you wish to avail yourself of my ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Make 1st 0 show in Word mail merge from Excel data source?
    ... See the zip code section of "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at ... Please reply to the newsgroup unless you wish to avail yourself of my ...
    (microsoft.public.word.mailmerge.fields)
  • Re: zip codes formatted in Excel are not replicated in Word. How do .
    ... See "Formatting Word fields with switches" on fellow MVP Graham Mayor's ... Please reply to the newsgroup unless you wish to avail yourself of my ...
    (microsoft.public.word.mailmerge.fields)