Open email in HTML format

  • Thread starter Thread starter Sunflower
  • Start date Start date
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
 
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
 
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
 
Back
Top