Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to open an email from excel with special body, subject, etc etc
and works perfectly with office 2003 (which I have). Sent it to somebdy with office 2000 and did not work, but changed the reference to an older one, and worked on both (off XP and off 2000) but it did not on Office XP!!! that was weird... HELP! HELP! Here's the code. Dim myOlapp As New Outlook.Application Dim myOLItem As Outlook.MailItem Dim myVar As Integer Set myOLItem = myOlapp.CreateItem(olMailItem) myVar = 12 With myOLItem .Subject = MailSubject .To = Recipient .Body = Mailbody .Attachments.Add Attachment .Display End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail | Excel Programming |