View Full Version : Send Outlook Email from Excel
ETracker
10-17-2011, 11:05 AM
I am looking for a line of code that would allow a request a read receipt back from the person the email was sent to.
I have the code to send the email, I am only trying to get the read receipt.
Thanks for any help.
ETracker
mancubus
10-17-2011, 02:02 PM
Dim objOutlook As Object
Dim objMailItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objMailItem = objOutlook.CreateItem(olMailItem)
With objMailItem
.To = "xx@xxx.com"
.CC = ""
.BCC = ""
.Subject = "Subject"
.Body = "Body"
.Attachments.Add ActiveWorkbook.FullName
.ReadReceiptRequested = True
End With
ETracker
10-17-2011, 05:39 PM
Thanks Mancubus,
I will add this to my existing code and I am sure based on your code that this is just what I am looking for.
Again Thanks.
ETracker :yes
mancubus
10-18-2011, 12:55 AM
you're wellcome ETracker.
it's from VBA help.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.