Hi Peter,
One possibility is to save the Excel ws to a csv file, then use that as the mailmerge data source.
--
Cheers
macropod
[Microsoft MVP - Word]
"Peter Jamieson" wrote in message ...
I'm
quite disappointed that integrating them has been so difficult.
Yes, it is disappointing.
I don't know what the best way to get text versions of the dates into
another column would be, or how well that would work if you still have a
column with material that /looks like/ mixed data types.
Not being an Excel expert and finding no obvious worksheet function to
do the job in the Text functions group, I'd probably start by writing an
Excel VBA worksheet formula such as
Function astext(sourcecell As Range) As String
astext = sourcecell.text
End Function
and put
=astext(the source cell address)
in each cell in the target column, but I assume there is actually a
better way.
Peter Jamieson
http://tips.pjmsn.me.uk
MaxArk wrote:
Peter Jamieson;3341863 Wrote:
solid workplace tool for others to use, Word-Excel connections are a
crock.
LOL.
I've spent months working on a great Excel based data processing
application. Excel is my tool of choice. Word has a great presentation
feature with it's mail merge feature, something Excel lacks in. I'm
quite disappointed that integrating them has been so difficult.
What I may consider doing is changing all the date and time cells in
the Excel database to simple text once all the calculations are
complete. The database uses these values in calculations, so an
additional step will be needed to copy the contents of the processed
database to a separate worksheet, one with cells being all text. Now
.. how complicated will it be to convert date formatted 21-May-09 to
pure text 21-May-09?
Jenn