Excel & Outlook

  • Thread starter Thread starter gti_jobert
  • Start date Start date
G

gti_jobert

Hi all,

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


Code:
--------------------

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"
.Display
.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?

TIA
 
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:
 
Back
Top