File format change

[puthenveetil]

Hi all,

I had a form with a command button which invokes email sending option to send a report..I am using code sample which I got from this forum.I thank that guy for posting that code in this forum. The code which I am using is here:-

'This will create the e-mail

DoCmd.SendObject acReport, "Rpt_Customer", "RichTextFormat(*.rtf)", "", "", , "Customer Report", "", False, ""

'Tbis explains all the section of the e-mail see SendObject in help
Rem example from help DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]


The code is working perfect and my question is that can I change the file format from RichTextFormat to word format????? I tried by chaning "WordDocument (*.doc)" but it didn't worked???? Is there any way I can change that to word format (*.doc)???? any suggestions appreciated


thanks in advance


Thanks

 

[DES]

The output formats for this process are: acFormatDAP; acFormatHTML; FormatRTF; acFormatTXT; acFormatXLS.

There is not one for Word specifically but Word can open the RTF and TXT formats as well as the HTML for that matter.

You have to look at it this way. These formats are standards that can be imported into multiple applications. For example the RTF can be opened with Word or WordPerfect or Word etc. What you are missing is what RTF is. RTF stands for Rich Text Format which again is a standard that allows for formatting a document as opposed to a TXT format which is non formated.

Stick with the RTF and Word should open it just fine.