SendObject Outlook template (1 Viewer)

Erin Cimbrie · Nov 10, 2010

I have a Template email message saved as an HTML file that I would like a SendObject macro to use when it opens a new email message.

In the SendObject macro, I have typed the following in the Template File argument:
"C:\Documents and Settings\cimbrie\AA Database\Invoice test Template_files".

I have tested the link by clicking on it in Word and it takes me to the AA Database folder and selects the file. I interpret that to mean the path is right.

The SendObject does not open the template. It just opens a new email.

Any body see what I am doing wrong?

Trevor G · Nov 11, 2010

I don't see any file extension in your path?

Word would be .dot
Excel would be .xlt
Outlook would be .oft

Erin Cimbrie · Nov 11, 2010

Thanks for the reply.
I tried filename.oft
filename\*.oft
filename.oft_files

None of them worked.

Trevor G · Nov 12, 2010

Trevor G said:
I don't see any file extension in your path?

Word would be .dot
Excel would be .xlt
Outlook would be .oft

The path would be written as

"c:\path to template\template name.oft"

Have you created this in vba?

Are you using this internally or for external? If external your recipients may not see your template if they don't use outlook

Trevor G · Nov 12, 2010

Just out of interest are you using the Access send object as this means you are sending Tables, Queries, Forms, Reports, not Outlook.

I would be interested in seeing your code or macro.

ChrisSedgwick · Nov 21, 2017

Did this ever get resolved as I have the same issue?

SendObject Outlook template (1 Viewer)

Erin Cimbrie

Registered User.

Trevor G

Registered User.

Erin Cimbrie

Registered User.

Trevor G

Registered User.

Trevor G

Registered User.

ChrisSedgwick

Registered User.

Similar threads

Users who are viewing this thread