Mail merge problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Givvie - 11 May 2006 11:49 GMT

I have inserted a field into a mail merge document and when I merge / view
the document the numerical figure I have chosen ends up being a figure with
many decimal points eg 720.234654 instead of 720 as it is in my data source
(excel spread sheet)
How do you get the figure to just be 720?
I am using Word 2003 and excel 2003

Reply to this Message

Graham Mayor - 11 May 2006 13:38 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I have inserted a field into a mail merge document and when I merge /
> view the document the numerical figure I have chosen ends up being a
> figure with many decimal points eg 720.234654 instead of 720 as it is
> in my data source (excel spread sheet)
> How do you get the figure to just be 720?
> I am using Word 2003 and excel 2003

Reply to this Message

Givvie - 11 May 2006 14:23 GMT

Thanx Graham - Although a little confusing to begin with I soon got the jist
of it and managed to work it out from the info you supplied.

cheeeeeeerrrrrssssss........;-)

> See http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 4 lines]
> > How do you get the figure to just be 720?
> > I am using Word 2003 and excel 2003

Reply to this Message

Cindy M -WordMVP- - 11 May 2006 14:45 GMT

Hi =?Utf-8?B?R2l2dmll?=,

> I have inserted a field into a mail merge document and when I merge / view
> the document the numerical figure I have chosen ends up being a figure with
> many decimal points eg 720.234654 instead of 720 as it is in my data source
> (excel spread sheet)
> How do you get the figure to just be 720?
> I am using Word 2003 and excel 2003

You have a number of choices. The "simplest" is probably to include a
numerical formatting switch in the mail merge field code:

1. Alt+F9 to display the field codes
2. At the end of the field, type in the switch. Example:
{ Mergefield Total \# "0" $
3. Alt+F9 again to hide the field codes.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

Squeak - 12 May 2006 19:38 GMT

Hello all...

I too am trying to format an AMT filed and a SSN filed imported from EXCEL.
where do I include the switch?

this is my field: «OUTDENTALAMT____»

> Hi =?Utf-8?B?R2l2dmll?=,
>
[quoted text clipped - 20 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message

Squeak - 12 May 2006 19:40 GMT

Hello all...

I too am trying to format an AMT filed and a SSN filed imported from EXCEL.
where do I include the switch?

this is my field: «OUTDENTALAMT____»

thanks for the help

Reply to this Message

Doug Robbins - Word MVP - 12 May 2006 22:24 GMT

Press Alt+F9 to toggle on the display of field codes and 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

> Hello all...
>
[quoted text clipped - 5 lines]
>
> thanks for the help

Reply to this Message

Christina - 27 Jun 2006 23:07 GMT

I am a newbie and don't understand what you mean by saying to press ALT+F9 to
display the field codes. Where do I do this in excel or word?

> Hi =?Utf-8?B?R2l2dmll?=,
>
[quoted text clipped - 20 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message

Doug Robbins - Word MVP - 28 Jun 2006 04:42 GMT

In Word.

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

>I am a newbie and don't understand what you mean by saying to press ALT+F9
>to
[quoted text clipped - 27 lines]
>> This reply is posted in the Newsgroup; please post any follow question or
>> reply in the newsgroup and not by e-mail :-)

Reply to this Message

hirendra7158 - 24 Jun 2007 03:57 GMT

SIr/Ma'am,
I really do not know whether this si the right plateform or place to ask you
my question, but encouraged by your reply I am tempted to ask you. Please
pardon me and direct me toa right place if you find this place to be
incorrect. but please please reply.
After Mail merging, in Word 2003, names and data of 100 students, in to a
small five line document that needs to posted to parents of each student,
printing each of the Mail Merged document on a separate A4 sized sheet of
paper is uneconomical. I am trying to print TWO merged documents on a single
A4 sized sheet. How do I do it. PLease guide and oblige.
thanks.
I would be grateful if you will send me a copy of the reply to
"hirendra7158@yahoo.co.in" also.
Many thanks.

> Hi =?Utf-8?B?R2l2dmll?=,
>
[quoted text clipped - 20 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message