Excel & Outlook



Hi all,

I have a Mail Sub to send emails to suppliers with attached orders;


Sub SendAnEmailWithOutlook(CurrFile)

Dim olApp As Outlook.Application
Dim olMail As MailItem

Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)

With olMail
.To = "(e-mail address removed)"
.CC = "(e-mail address removed)"
.Subject = "Textron Schedule Agreements: " & Right(CurrFile, 13)
.Attachments.Add CurrFile & ".xls"
.OriginatorDeliveryReportRequested = True
.ReadReceiptRequested = True
End With

Set olMail = Nothing
Set olApp = Nothing

End Sub


I want to be able to find out (from excel) whether or not the user
actually sent this mail to the supplier - is this possible?



Not sure if there was a way to find out the session details from the
olApp, and if the user clicks 'Send' then set something to true?!

Any ideas appreciated here, a lil lost :eek:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question