LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Excel VB to create and send an outlook appointment with html code

Hi Matt

Not tested, sorry (no Outlook on my private computers)

With OutMail
'... replace ".Body = ... " with
.HTMLBody = "<HTML<BODY<BBold text</B plain text.</BODY</HTML"
'...
End With

theory on
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

HTH. Best wishes Harald

"Matt" skrev i melding
...
I have started writing the code for what I want done. I have a worksheet
with 40 columns and 200 rows. I can get all the data I want and open up an
outlook appointment and even add an attachment. I am having issues of
trying to make the body of the text html (change some words to red and bold
them). When I change the line ".Body = email_Msg & vbCrLf & vbCrLf &
Signature", it doesn't allow any formatting. I am having some issues. Can
you please help?

Matt

(SNIP)

With OutMail
.Recipients.Add "
.Subject = "Welcome" & sFull_Name
.Location = "420 Overthere St, Houston, TX 77002 (Security Desk /
Ground Floor Lobby)"
.Start = sStart_Date & " 8:00:00 AM"
.Duration = 510
.AllDayEvent = "False"
.MeetingStatus = olMeeting
.Attachments.Add sFileNameZip
.Body = email_Msg & vbCrLf & vbCrLf & Signature
.Display 'or use .Send
End With



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Appointment in Outlook [email protected] Excel Programming 1 March 6th 09 05:26 AM
Automatically create outlook appointment Alarmbloke Excel Discussion (Misc queries) 0 March 12th 06 08:47 PM
Macro to create a Outlook Appointment from excel cell data Alarmbloke Excel Programming 1 January 27th 06 03:49 PM
Create a button in excel that can open an outlook appointment? Movieman Excel Worksheet Functions 1 July 15th 05 12:20 AM
make appointment in outlook and send email reminder - all data in excel 2000 DL[_3_] Excel Programming 2 August 5th 03 11:08 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"