Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delivery receipt when auto emailing
Hello there, I'm using the following code for auto emailing from excel.
Everything is wonderful except when I add in the line to request a delivery receipt. Can someone advise please? Thanks & regards, Brett Gregory. ActiveWorkbook.EnvelopeVisible = True With ActiveSheet.MailEnvelope .Introduction = "" .Item.To = Workbooks("1. TOOLS.xls").Sheets("CONTACTS").Range("AG" & clientline).Value .Item.Subject = Sheets("EMAIL").Range("subject").Value .Item.Importance = 2 .Item.DeliveryReceiptRequested = True .Item.ReadReceiptRequested = True .Item.Attachments.Add Sheets("EMAIL").Range("O4").Value .Item.send Application.Wait (Now + TimeValue("0:00:05")) Application.SendKeys "{LEFT}" Application.SendKeys "{ENTER}" End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overdue Delivery Dates | New Users to Excel | |||
DELIVERY NOTES | Excel Worksheet Functions | |||
How do I insert an auto signature if emailing from excel? | Excel Discussion (Misc queries) | |||
Order Delivery Schedule | Excel Discussion (Misc queries) | |||
Delivery note or delivery order sheet | Excel Discussion (Misc queries) |