Trouble formatting Excel data to be recognized when merged into Wo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobsgirl - 15 Sep 2004 00:15 GMT

Have a spreadsheet that has a column with room numbers i.e. 101, 102, 2A, 2B.
When merging these room numbers into Word the room numbers consistenting of
alpha characters act as nonexistent. I have tried General, Number, Text, and
even created my own Special format but nothing seems to work. I've had a
similar problem in the past with zip codes which seem pretty basic to me! I
can only reliably merge the zip codes if there is an "error" in my Excel cell
"Number Stored as Text". Would appreciate help!

Reply to this Message

Doug Robbins - 15 Sep 2004 02:04 GMT

Under Tools>Options>General, check the "Confirm conversions and open" box
and when you attach the data source to the mailmerge main document, use DDE.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Have a spreadsheet that has a column with room numbers i.e. 101, 102, 2A,
> 2B.
[quoted text clipped - 8 lines]
> cell
> "Number Stored as Text". Would appreciate help!

Reply to this Message

Bobsgirl - 15 Sep 2004 02:27 GMT

Thank you so much for your time! My "confirm conversions" box was already
checked but was unable to find how to use DDE. When connecting my data
source under "Provider" I used OLE DB and under "Connection" my only options
were dBase, Excel, and Access. How do I choose DDE?

> Under Tools>Options>General, check the "Confirm conversions and open" box
> and when you attach the data source to the mailmerge main document, use DDE.
[quoted text clipped - 11 lines]
> > cell
> > "Number Stored as Text". Would appreciate help!

Reply to this Message