Extracting to Excel then Merging to Word - 2000 vs 2003 difference

[davsch9800]

In 2000 this has worked for years, now it dies as I test it in 2003.

A query outputs to a default Excel file.
Opens a default Word template that runs SELECT * FROM ... previous Excel file
Then in Word, you just select the Merge button and it will populate all the
fields.

BUT, the difference I am seeing in 2003, is that the Excel file closes so
the Word doc does not know what to Merger.

I have:
Played with the "Update Auto Links" in Tool - Options.
Lowered Security setting in Access, Excel and Word.
No luck.

Any help is appreciated.

DS

 

[Arvin Meyer MVP]

Why not merge it directly from Access?

 

[davsch9800]

Just trying to do less work. I was not the one who wrote it and I am hoping
it will be easier to adjust it rather than rewrite it.

 

[Mark Andrews]

You could checkout http://www.rptsoftware.com/products/email/

I designed it to help with some of your issues, it does a few extra things
but you might be interested.

Mark