sending report as an attachment

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

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

Thanks
 
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.
 
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
 
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.
 
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
 
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
 
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...
 
Back
Top