Displaying mail with Excel
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
|