Open email in HTML format

S

Sunflower

I have the following...
--------------------------------------------------------------------
Form- frmWOEDIT

Command Button- cmdSendAproval


Macro Name- cmdEmailRequesterTo : On Click

Action- SendObject

To- =IIf([DEPTID]="90","Name1; Name2; Name3; Name4; Name5",[Requestor]
& ";Name1; Name2; Name3")

Cc- =IIf([DEPTID]="90","Name6; Name7","Name6")

Subject- ="APPROVAL for WO#" & [WOID] & " - " & [ProjectName]

Message Text- ="Please Proof WO#" & [WOID] & " - " & [ProjectName] &
" - Reply to this email with any changes or approval by 3 p.m. on " &
Format(Date()+1,"dddd mmm dd,yyyy")

Edit Text- Yes
---------------------------------------------------------------------------------

This all works...except it opens as plain text
What I need it to do is open as HTML format for pasting a screen
capture into the body.

All and any help much appreciated
 
S

Steve Schapel

Sunflower,

I am sorry, the SendObject action/method does not support HTML format
emails.

You could save your screen capture as an image file, and add it to the email
as an attachment.

Otherwise you will need to look at alternative ways of sending the emails.
For which, here is a useful starting point
http://www.granite.ab.ca/access/email.htm

--
Steve Schapel, Microsoft Access MVP


Sunflower said:
I have the following...
--------------------------------------------------------------------
Form- frmWOEDIT

Command Button- cmdSendAproval


Macro Name- cmdEmailRequesterTo : On Click

Action- SendObject

To- =IIf([DEPTID]="90","Name1; Name2; Name3; Name4; Name5",[Requestor]
& ";Name1; Name2; Name3")

Cc- =IIf([DEPTID]="90","Name6; Name7","Name6")

Subject- ="APPROVAL for WO#" & [WOID] & " - " & [ProjectName]

Message Text- ="Please Proof WO#" & [WOID] & " - " & [ProjectName] &
" - Reply to this email with any changes or approval by 3 p.m. on " &
Format(Date()+1,"dddd mmm dd,yyyy")

Edit Text- Yes
---------------------------------------------------------------------------------

This all works...except it opens as plain text
What I need it to do is open as HTML format for pasting a screen
capture into the body.

All and any help much appreciated



__________ Information from ESET Smart Security, version of virus signature database 4164 (20090617) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
S

Sunflower

Sunflower,

I am sorry, the SendObject action/method does not support HTML format
emails.

You could save your screen capture as an image file, and add it to the email
as an attachment.

Otherwise you will need to look at alternative ways of sending the emails..
For which, here is a useful starting pointhttp://www.granite.ab.ca/access/email.htm

--
Steve Schapel, Microsoft Access MVP






I have the following...
Command Button- cmdSendAproval
Macro Name- cmdEmailRequesterTo : On Click
Action- SendObject
To- =IIf([DEPTID]="90","Name1; Name2; Name3; Name4; Name5",[Requestor]
& ";Name1; Name2; Name3")
Cc- =IIf([DEPTID]="90","Name6; Name7","Name6")
Subject- ="APPROVAL for WO#" & [WOID] & " - " & [ProjectName]
Message Text- ="Please Proof  WO#" & [WOID] & " - " & [ProjectName]&
" - Reply to this email with any changes or approval by 3 p.m. on " &
Format(Date()+1,"dddd  mmm dd,yyyy")
Edit Text- Yes
---------------------------------------------------------------------------­------
This all works...except it opens as plain text
What I need it to do is open as HTML format for pasting a screen
capture into the body.
All and any help much appreciated

__________ Information from ESET Smart Security, version of virus signature database 4164 (20090617) __________

The message was checked by ESET Smart Security.

http://www.eset.com- Hide quoted text -

- Show quoted text -

Thank you for your response..I will check out the link
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top