How can I avoid only getting a 0 when mailmerge an itn'l phone nu.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathym - 18 Jan 2006 20:58 GMT

I have an extensive list of address information in an Excel database.
Included are international phone numbers. When I do a mailmerge into a Word
document, all the international phone numbers show up only as a zero. I can't
find a way to change this. Thank you.

Reply to this Message

Graham Mayor - 19 Jan 2006 07:22 GMT

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> I have an extensive list of address information in an Excel database.
> Included are international phone numbers. When I do a mailmerge into
> a Word document, all the international phone numbers show up only as
> a zero. I can't find a way to change this. Thank you.

Reply to this Message

Kathym - 19 Jan 2006 13:21 GMT

Graham, thank you, but I can't find the answer. I don't see what changes I
need to make. Can you pls be specific? Thank you again.

> I have an extensive list of address information in an Excel database.
> Included are international phone numbers. When I do a mailmerge into a Word
> document, all the international phone numbers show up only as a zero. I can't
> find a way to change this. Thank you.

Reply to this Message

Graham Mayor - 19 Jan 2006 14:05 GMT

The Excel Data section indicates how to connect the merge to Excel by using
the DDE connection method, which will bring across the data as you have it
in Excel.

The alternative is to format the data as numbers in Excel and add a
formatting switch to layout the numbers
http://www.gmayor.com/formatting_word_fields.htm according to the format you
require.

Signature

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

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

> Graham, thank you, but I can't find the answer. I don't see what
> changes I need to make. Can you pls be specific? Thank you again.
[quoted text clipped - 3 lines]
>> a Word document, all the international phone numbers show up only as
>> a zero. I can't find a way to change this. Thank you.

Reply to this Message

Kathym - 19 Jan 2006 14:58 GMT

Sorry to be a pain. I did see the DDE section in Excel, and I changed to that
in the Word options. But it didn't make any difference. And, because I have a
whole variety of data formats, I can't select just one formatting to use.

> The Excel Data section indicates how to connect the merge to Excel by using
> the DDE connection method, which will bring across the data as you have it
[quoted text clipped - 12 lines]
> >> a Word document, all the international phone numbers show up only as
> >> a zero. I can't find a way to change this. Thank you.

Reply to this Message

Doug Robbins - Word MVP - 19 Jan 2006 20:13 GMT

Just how do you have the numbers entered into the Excel spreadsheet?

With Word 2003, using the default connection method (that is without the
Confirm conversions at open checked), numbers that I enter into a cell with
General formatting as '+12139851224 (the format used by a mobile phone so
that it can be called from any location)or as '+1 (213) 985-1224 the format
used in Outlook or entered into a cell that is formatted as text as
+12139851224 or +1 (213) 985-1224 in all cases appear in the merged document
exactly as displayed in Excel.

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

> Sorry to be a pain. I did see the DDE section in Excel, and I changed to
> that
[quoted text clipped - 21 lines]
>> >> a Word document, all the international phone numbers show up only as
>> >> a zero. I can't find a way to change this. Thank you.

Reply to this Message