Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Outlook
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 = " .CC = " .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 -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=544734 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Outlook
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 -- gti_jobert ------------------------------------------------------------------------ gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634 View this thread: http://www.excelforum.com/showthread...hreadid=544734 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Outlook 11 Outlook 10 Object Library Compatibility Issues | Excel Programming | |||
Outlook Automation Error Problem - Can't locate Outlook Module | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming |