docmd sendobject

[mikeba1]

Can anyone provide me with an example/syntax of the sendobject command where it uses a template

thanks

 

[TheAceMan1]

How are ya mikeba1 . . .

In which arguement are yo having a problem ... or ... what is the syntax you've attempted to use?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[mikeba1]

Thanks for the reply
The code is as follows

DoCmd.SendObject acSendReport, "PSIADTESTRA1", acFormatrtf, !ConcEmail, , , "Remittance Advice ", , True, "c:\testtemp.oft"

It all works apart from the templatefile, which does not appear when outlook opens.
The template is an oft html page.
When outlook opens the page is text , I want to be html, hence the template.
Is there any other way to make the outlook email html rather than text

 

[TheAceMan1]

mikeba1 . . .

You use [blue]acFormatRTF[/blue]. Shouldn't it be [blue]acFormatHTML[/blue]?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[mikeba1]

I assume
The acformatrtf is used for the format of the attachment only.
The sendobject property 'Templatefile' is used( If it worked) to format the email
This does not work in Access 2003/2007 using outlook 2003/2007
Another microsoft problem??