mail merge word xp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

t schreiber - 27 Dec 2003 22:15 GMT

Letter mail merge word97 is fine but wordxp is the pits.
1) The number data in xp is unformateded e.g. 20 number beyond the
decimal pointe when the data source (access or excel) is formated for 2
decimal points. Works fine in 97 but cannot run 97 and xp on same
computer.
2) XP will not allow the use of queries as the files are being merged.
97 allows queries and sorting even for excel data.
SOMEONE MISSED THE BOAT ON THIS ONE!!!

------------------------------------------------

Reply to this Message

Graham Mayor - 28 Dec 2003 06:17 GMT

Microsoft has merely changed the default connection method between Word and
other Office products and so Word is now expected to provide the formatting.
You can revert to the old method or work with it. See the Excel data section
of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Letter mail merge word97 is fine but wordxp is the pits.
> 1) The number data in xp is unformateded e.g. 20 number beyond the
[quoted text clipped - 9 lines]
> ~~View and post usenet messages directly from
> http://www.ExcelForum.com/

Reply to this Message

Paul - 29 Dec 2003 16:12 GMT

Just read this post about wordXP.

I am trying to merge excel figures in GBPounds into a
wordXP document and have had the same problem. By
formatting the excel column to currency or accounting and
inserting the £ sign you lose the decimal points but if
the pence is exactly to 10p i.e. £134.40 it shows as £134.4

Does any one have the solution, short of formatting the
spreadsheet to text and manually adding a 0 after each
missing item?

Thanks.

Paul

>-----Original Message-----
>
[quoted text clipped - 10 lines]
>
>~~View and post usenet messages directly from

http://www.ExcelForum.com/

Reply to this Message

Graham Mayor - 29 Dec 2003 17:04 GMT

The answer is in the thread to which you attached your question, however
there is a simple method to deal with this issue - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Just read this post about wordXP.
>
[quoted text clipped - 29 lines]
>>
>> .

Reply to this Message