ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mail merge format is driving me nuts - again (https://www.excelbanter.com/excel-discussion-misc-queries/98623-mail-merge-format-driving-me-nuts-again.html)

pjm

Mail merge format is driving me nuts - again
 

I have an excel spreadsheet with various columns of information. The
text values were displaying as 0 in this one particular column -it has
some cells with text and some with numeric values if that matters.. So,
I previously did the confirm conversion option / ms excel worksheet via
DDE (*.xls) / select my range ... which did solve the problem for a
while but ..
Now every time I open it, it cant find my data source (even though it
does open the workbook) so I have to close it, re-open, choose not to
run the SQL command to select my data source & start over at the
begining of the entire process each time I want to merge a document. It
will work that way .. but it wont save.

Help .. I have a nice monitor .. going to toss it over the cubical soon
|:

..............Please - Thank you................


--
pjm
------------------------------------------------------------------------
pjm's Profile: http://www.excelforum.com/member.php...o&userid=36132
View this thread: http://www.excelforum.com/showthread...hreadid=560197



All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com