VBA generate a word doc and email it

[kevinonearth]

HI there,
I use Hui's VBA macro to generate a word document in a specific folder
(http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/)

But what if I want to email the word doc rather than save it to a folder?
How do I go about that?

Thanks
Kevin

 

[bobhc]

Good day kevinonearth

If you cannot find what you what in the link then it probably does not exists.

http://www.rondebruin.nl/win/section1.htm

 

[kevinonearth]

Hi Bobhc
yes I've checked that already.
What I'm really asking is when using the code supplied bu Hui here:
http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/

At what point can I capture the new word file generated and send it to the Outlook application?
Thanks
Kevin

 

[SirJB7]

Hi, kevinonearth!

No chance you can attach a file to an email if the file isn't stored in a folder, so to send a Word document you first have to save the data that's in memory handled by the Word application and then attach it to an email.

Regarding your question, after this lines:

' Save new file
objWord.ActiveDocument.SaveAs cDir + NewFileName

you have the Word file created. So using it there (i.e., trapping it and attaching to the email) would be your 1st choice.

Regards!

 

[kevinonearth]

Ok, thanks, but having captured it, what is the code to use to email it?

' Save new file
objWord.ActiveDocument.SaveAs cDir + NewFileName

at this point do I create a new variable?
And how do I get VBA to send it to outlook?
Would it help if I attached the file here?

Thank you

 

[SirJB7]

Hi, kevinonearth!

Does this help?
http://www.rondebruin.nl/win/section1.htm
You have a lot of stuff regarding email in there.

I suggest you to go thru the sublinks and give it a try, it's one of the best ways to learn. But just in case you couldn't manage to handle it, just come back and someone'd surely will help you.

Regards!