Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jbrzez jbrzez is offline
external usenet poster
 
Posts: 5
Default Field format from Excel

I am trying to MailMerge a field from an Excel document. The field is for
Phone Numbers and has been formatted to display them with the area code and
middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is in Word?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Field format from Excel

See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I am trying to MailMerge a field from an Excel document. The field
is for Phone Numbers and has been formatted to display them with the
area code and middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is
in Word?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jbrzez jbrzez is offline
external usenet poster
 
Posts: 5
Default Field format from Excel

I don't have full interent here at work (thought this was the 21st century)
so I can't access the site. Any way to describe or list the steps?

"Graham Mayor" wrote:

See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I am trying to MailMerge a field from an Excel document. The field
is for Phone Numbers and has been formatted to display them with the
area code and middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is
in Word?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Field format from Excel

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I don't have full interent here at work (thought this was the 21st
century) so I can't access the site. Any way to describe or list the
steps?

"Graham Mayor" wrote:

See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I am trying to MailMerge a field from an Excel document. The field
is for Phone Numbers and has been formatted to display them with the
area code and middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is
in Word?



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jbrzez jbrzez is offline
external usenet poster
 
Posts: 5
Default Field format from Excel

Thanks. It worked great.

"Graham Mayor" wrote:

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I don't have full interent here at work (thought this was the 21st
century) so I can't access the site. Any way to describe or list the
steps?

"Graham Mayor" wrote:

See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:
I am trying to MailMerge a field from an Excel document. The field
is for Phone Numbers and has been formatted to display them with the
area code and middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is
in Word?






  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kathy Williamson Kathy Williamson is offline
external usenet poster
 
Posts: 1
Default the fix doesn't work

I am trying to use this fix, and I am having a problem. I am trying to import numbers and I need it to show one decimal place (i.e. 15.9) and instead it comes over as 15.49990000...etc. I tried the fix and when I put the changes in, it deletes my cell information so that all is { \# "0.0"}. And when I perform the merge, this area is blank.
However, my mailmerge field does not display as you describe. It comes in as CGOVT and when I display the field display it is { GGOVT }. I have tried entering the fix both before the and after, and I get the same results.
In addition to this problem, some of my cell fields are missing when I try to select recipients. For example, I have a cell named CGOVT and one named CGOVT1. The second is missing from the list.
Additional info: originally this file was in 2003. However, even when I set up a new merge file in 2007, I get the same result.
Please help!!!!
Just Lady



Graham Mayor wrote:

Add a switch to the mergefieldRight click and toggle the field display to
30-Jan-07

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

Previous Posts In This Thread:

On Tuesday, January 30, 2007 9:03 AM
jbrze wrote:

Field format from Excel
I am trying to MailMerge a field from an Excel document. The field is for
Phone Numbers and has been formatted to display them with the area code and
middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is in Word?

On Tuesday, January 30, 2007 9:11 AM
Graham Mayor wrote:

Field format from Excel
See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

On Tuesday, January 30, 2007 9:24 AM
jbrze wrote:

I don't have full interent here at work (thought this was the 21st century) so
I do not have full interent here at work (thought this was the 21st century)
so I cannot access the site. Any way to describe or list the steps?

"Graham Mayor" wrote:

On Tuesday, January 30, 2007 10:14 AM
Graham Mayor wrote:

Add a switch to the mergefieldRight click and toggle the field display to
Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

On Tuesday, January 30, 2007 10:24 AM
jbrze wrote:

Field format from Excel
Thanks. It worked great.

"Graham Mayor" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Join Lists with LINQ - SharePoint 2010
http://www.eggheadcafe.com/tutorials...-linq--sh.aspx
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default the fix doesn't work

If when you use Alt+F9 to toggle on the display of field codes «GGOVT» is
not replaced by { MERGEFIELD GGOVT } then «GGOVT» is NOT a mergefield.

If you are merely using the { and } keys on the keyboard to insert the { }
then that is not the same thing. You must use Alt+F9 and the when the

{ MERGEFIELD GGOVT } appears, add the formatting switch inside the closing }

{ MERGEFIELD GGOVT \# 0.0 }

When you use Alt+F9 again to toggle off the display of the field codes, you
will see «GGOVT» again, and when you execute the merge, the result will be
displayed with one decimal point.

I cannot tell what is wrong with your data source, but if you want to send a
copy of it to me, I will take a look at if for you.

--
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, originally posted via msnews.microsoft.com

"Kathy Williamson" wrote in message
...
I am trying to use this fix, and I am having a problem. I am trying to
import numbers and I need it to show one decimal place (i.e. 15.9) and
instead it comes over as 15.49990000...etc. I tried the fix and when I
put the changes in, it deletes my cell information so that all is { \#
"0.0"}. And when I perform the merge, this area is blank.
However, my mailmerge field does not display as you describe. It comes in
as CGOVT and when I display the field display it is { GGOVT }. I
have tried entering the fix both before the and after, and I get the
same results.
In addition to this problem, some of my cell fields are missing when I try
to select recipients. For example, I have a cell named CGOVT and one
named CGOVT1. The second is missing from the list.
Additional info: originally this file was in 2003. However, even when I
set up a new merge file in 2007, I get the same result.
Please help!!!!
Just Lady



Graham Mayor wrote:

Add a switch to the mergefieldRight click and toggle the field display to
30-Jan-07

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

Previous Posts In This Thread:

On Tuesday, January 30, 2007 9:03 AM
jbrze wrote:

Field format from Excel
I am trying to MailMerge a field from an Excel document. The field is for
Phone Numbers and has been formatted to display them with the area code
and
middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is in
Word?

On Tuesday, January 30, 2007 9:11 AM
Graham Mayor wrote:

Field format from Excel
See the examples at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

On Tuesday, January 30, 2007 9:24 AM
jbrze wrote:

I don't have full interent here at work (thought this was the 21st
century) so
I do not have full interent here at work (thought this was the 21st
century)
so I cannot access the site. Any way to describe or list the steps?

"Graham Mayor" wrote:

On Tuesday, January 30, 2007 10:14 AM
Graham Mayor wrote:

Add a switch to the mergefieldRight click and toggle the field display to
Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jbrzez wrote:

On Tuesday, January 30, 2007 10:24 AM
jbrze wrote:

Field format from Excel
Thanks. It worked great.

"Graham Mayor" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Join Lists with LINQ - SharePoint 2010
http://www.eggheadcafe.com/tutorials...-linq--sh.aspx


Reply
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
Mailmerge merged field format Liz T NN14 Mailmerge 2 November 19th 06 09:35 AM
Percentage format in merge from excel Lica Mailmerge 7 November 17th 06 11:30 AM
Create Date field format Mary Ann Microsoft Word Help 3 November 6th 06 02:18 PM
Insert Field - Database - Wrong Date Format dns2005 Mailmerge 3 February 23rd 06 04:04 PM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 07:34 AM


All times are GMT +1. The time now is 09:48 PM.

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"