Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Appointment in Outlook | Excel Programming | |||
Automatically create outlook appointment | Excel Discussion (Misc queries) | |||
Macro to create a Outlook Appointment from excel cell data | Excel Programming | |||
Create a button in excel that can open an outlook appointment? | Excel Worksheet Functions | |||
make appointment in outlook and send email reminder - all data in excel 2000 | Excel Programming |