sending report as an attachment

A

Alexander

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

Thanks
 
A

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.
 
A

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
 
A

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.
 
A

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
 
J

Joe Black

Alexander said:
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.
Click to expand...
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
 
A

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


.
Click to expand...
 
Top