formatting change using mail merge in Office 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

I canoetoo - 31 Aug 2006 20:16 GMT

I use mail merge to fill in text and numerical fields in quotations. This
worked well when using Office XP however now that I changed to 2003 I have
problems. First I had to re-associate all of the fields but now everywhere I
put in a number in Excel the mail merge document shows an extra decimal
place. (i.e. Excel field => 4, mail merge field => 4.0)

Reply to this Message

Doug Robbins - Word MVP - 31 Aug 2006 22:03 GMT

See
http://www.gmayor.com/formatting_word_fields.htm
or see the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm (the issues with
Excel would be the same as for Access).

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 use mail merge to fill in text and numerical fields in quotations. This
> worked well when using Office XP however now that I changed to 2003 I have
> problems. First I had to re-associate all of the fields but now everywhere
> I
> put in a number in Excel the mail merge document shows an extra decimal
> place. (i.e. Excel field => 4, mail merge field => 4.0)

Reply to this Message

I canoetoo - 01 Sep 2006 13:43 GMT

Doug:
Thanks, I will try this.
BTW your second link to the Excel data section would not work for me.
Thanks again

> See
> http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 8 lines]
> > put in a number in Excel the mail merge document shows an extra decimal
> > place. (i.e. Excel field => 4, mail merge field => 4.0)

Reply to this Message

Doug Robbins - Word MVP - 01 Sep 2006 16:57 GMT

Worked fine for me when I clicked on the link.

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

> Doug:
> Thanks, I will try this.
[quoted text clipped - 17 lines]
>> > put in a number in Excel the mail merge document shows an extra decimal
>> > place. (i.e. Excel field => 4, mail merge field => 4.0)

Reply to this Message