Mail merge problem from Excel

I am trying to get some data from an Excel worksheet into Word by mail
merge. Two of the fields I have are telephone numbers (formatted as text to
retain the preceding 0). The second phone field goes into the merged
document OK, but the first only displays 0 whenever the number begins with a
0 or is blank.

Can anyone explain reason for and a way round this problem?

--
Ian
--

Ian,

see if this helps....

http://office.microsoft.com/en-ca/as...164951033.aspx


Jim


"Ian" <me@me.com> wrote in message
news:N3OIf.34323$K42.10979@newsfe7-win.ntli.net...
>I am trying to get some data from an Excel worksheet into Word by mail
>merge. Two of the fields I have are telephone numbers (formatted as text to
>retain the preceding 0). The second phone field goes into the merged
>document OK, but the first only displays 0 whenever the number begins with
>a 0 or is blank.
>
> Can anyone explain reason for and a way round this problem?
>
> --
> Ian
> --
>
>

Thanks, Jim. The DDE method worked perfectly!

--
Ian
--
"Jim" <lakerfan426@yahoo.com> wrote in message
news:S_2dnSL_gZUQ2GjeRVn-tg@comcast.com...
> Ian,
>
> see if this helps....
>
> http://office.microsoft.com/en-ca/as...164951033.aspx
>
>
> Jim
>
>
> "Ian" <me@me.com> wrote in message
> news:N3OIf.34323$K42.10979@newsfe7-win.ntli.net...
>>I am trying to get some data from an Excel worksheet into Word by mail
>>merge. Two of the fields I have are telephone numbers (formatted as text
>>to retain the preceding 0). The second phone field goes into the merged
>>document OK, but the first only displays 0 whenever the number begins with
>>a 0 or is blank.
>>
>> Can anyone explain reason for and a way round this problem?
>>
>> --
>> Ian
>> --
>>
>>
>
>