Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Steve Koenig
 
Posts: n/a
Default Mail Merge Fields

Merging between Excel and Word and all of the merge fields are picked up
correctly in the resulting Word document except for the Street Number field
when this field has a PO Box, eg PO Box 321. The result displayed is 0.
I just finished reviewing "Formatting Word fields with switches" on fellow
MVP Graham Mayor's website at

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

This web site was helpful as I learned to toggle between field display and
the result with ALT + F9. The field display shows the field name Street
Number cottectly. I am unclear that if there were any switches associated
with this Field Code would they in fact be displayed when displaying the
Field Name?

Not to bore anyone with everything I tried, but I have tried everything I
could think to do and still can't get the result to display a PO Box followed
by the number.
I tried formatting the column in Excel to text, no luck, then formatting the
column in Excel to general, still no luck. I even tried to just enter PO Box
as the "street number" and the actual number as the "Street Name", but again
the result for the Field "Street Number" results as 0.
I tried to delete all PO Box entries in Excel and format the column then
re-enter the data, still no luck.
Its just this one Field that isn't working. All of the other fields yield
the intentioned information.
I can't imagine what is going on here.
Can anyone help me with this?
Steve Koenig
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Mail Merge fields merge with different formatting KP Microsoft Word Help 1 February 22nd 06 12:01 PM
Mail Merge Numeric Merge Fields Patti - Hexagon Mailmerge 7 December 5th 05 01:28 PM
Mail merge - use specific fields in the contacts folder to customi Rachelle Mailmerge 1 November 29th 05 01:49 PM
mail merge not showing fields from outlook contacts Drew Mailmerge 2 January 27th 05 05:57 AM


All times are GMT +1. The time now is 12:02 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"