Word mail merge and attach to email (1 Viewer)

[harrisw]

I've created a button which basically opens a word document and populates it with information from a from.

This works ok.


When I try to attach the word doc to an outlook email it says that the word doc is open elsewhere.

task manager shows winword.exe open evn though at the end of the code I set all the objects to nothing

Any ideas?

 

[Travis]

You set the Variable = Nothing, you did not "Close" the Word Process.

Try adding the WordObject.Close to your code just before you set it to Nothing.

 

[harrisw]

Tried it and I get an error "method or data member not found"

at the begining i have

Dim objWord As Word.Application

at the end I set the objects to nothing

Anything else I can try?

 

[harrisw]

Fixed it I used wordobject.quit