PC Review


Reply
Thread Tools Rate Thread

Open email in HTML format

 
 
Sunflower
Guest
Posts: n/a
 
      17th Jun 2009
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
 
Reply With Quote
 
 
 
 
Steve Schapel
Guest
Posts: n/a
 
      18th Jun 2009
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" <(E-Mail Removed)> wrote in message
news:0a683584-2044-4f77-ba31-(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
 
Sunflower
Guest
Posts: n/a
 
      18th Jun 2009
On Jun 17, 9:11*pm, "Steve Schapel" <scha...@mvps.org.ns> wrote:
> 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
>
> "Sunflower" <luvsunflow...@gmail.com> wrote in message
>
> news:0a683584-2044-4f77-ba31-(E-Mail Removed)...
>
>
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -


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

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting to html format with html code in a memo field Ray Adams Microsoft Access External Data 0 7th Mar 2005 09:56 PM
Outlook and HTML- Can't display received emails in HTML format =?Utf-8?B?Sm9obiBGLiBTY2hyb2VkZXI=?= Microsoft Outlook Discussion 0 21st Sep 2004 04:45 AM
Sending email in HTML format - problems with Text Format Krish Microsoft Outlook Discussion 0 14th Jul 2004 08:40 AM
Can't open html format email in outlook xp Stanley Sin Microsoft Outlook 0 22nd Apr 2004 04:39 AM
HTML/XML format for Excel 2000. Multiple sheets in single HTML file xargon Microsoft Excel Misc 0 25th Feb 2004 10:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:02 AM.