sending report as an attachment

[Alexander]

How could I convert a report to MS Word format and send it
as an attachment (MS Outlook) by using VB?

Thanks

 

[Alexander]

Thanks everybody.
I've already resolved this in RTF format by using
SendObject.
But, it would be better to send it in MS Word.
Please, advise whether it's possible.

 

[Alex Dybenko]

What you can do - is to output report to RTF file, then open word with
createobject, open rtf there, save it as word file, and send it as file

 

[Alexander]

Thanks a lot Alex.

But, I'd like to do it by using VB without user's
involment, just clicking a button. For RTF it's no problem
because it's in VB for SendObject.
But, some users complain that they cannot open it in RTF.
This is why I thought may be to use doc format.

 

[Alex Dybenko]

what i mean - then you can open word from access, convert file and save it
without user interaction
try to do this manually in word, starting macro recorder - word will make
you a sample code to start with

 

[Joe Black]

Thanks a lot Alex.

But, I'd like to do it by using VB without user's
involment, just clicking a button. For RTF it's no problem
because it's in VB for SendObject.
But, some users complain that they cannot open it in RTF.
This is why I thought may be to use doc format.

snip

If they can't open an RTF then they probably haven't got MS Word installed.
Many people send RTF attachments because they can be read by Word but can
not contain VBA modules (eliminating risk of Word 'macro' viruses).

Regards - Joe

 

[Alexander]

Thanks a lot, guys.

-----Original Message-----


snip

If they can't open an RTF then they probably haven't got MS Word installed.
Many people send RTF attachments because they can be read by Word but can
not contain VBA modules (eliminating risk of Word 'macro' viruses).

Regards - Joe


.