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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefan64 - 28 Nov 2005 20:22 GMT

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???

Reply to this Message

Doug Robbins - Word MVP - 28 Nov 2005 20:28 GMT

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

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

Signature

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

> When using office 2003, I want to merge my data from Excel to Word
> (labels,
[quoted text clipped - 4 lines]
> phone # in Excel is (###) ###-#### and when merged is ##########.
> how can this be resolved???

Reply to this Message

Gladys - 07 Aug 2006 17:06 GMT

Laymans Term

Merge as normal
In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with phone number formats.
For example:
{ MERGEFIELD "Phone" \# "(###)'-'####" }
4. Press Alt+F9 to hide the field codes.
5. Update all labels
5. Save the Main Document

> 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???

Reply to this Message

Rate this thread: