Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is formating (zip & phone) lost when merging from Excel to Wo.
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??? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is formating (zip & phone) lost when merging from Excel to Wo.
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" wrote in message ... 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??? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is formating (zip & phone) lost when merging from Excel to Wo.
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 "Stefan64" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge | |||
Merging with Excel which has line feeds | Mailmerge | |||
Excel date format merging to Word XP version | Mailmerge | |||
How do you keep the currency format when merging data from Excel? | Mailmerge |