Mail merge problem from Excel

[Ian]

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?

 

[Jim]

Ian,

see if this helps....

http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx


Jim

 

[Ian]

Thanks, Jim. The DDE method worked perfectly!