Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba
|
|||
|
|||
![]()
I need to request Receipts from OUTLOOK but only for emails sent out from
EXCEL via the code below. Can modify the code to request reciept on an send basis via code? Thanks Bruce -------------- Sub UseDefSig(FileNAME) Dim ol As Outlook.Application Dim mi As MailItem Dim MyHtm As String Dim AutoSig As String Dim TheSig As String Dim strIn As String Dim FNum As Long FileNAME = "c:\scripts\" & FileNAME FNum = FreeFile Open FileNAME For Input As FNum Do While Not EOF(FNum) Line Input #FNum, strIn TheSig = TheSig & vbCrLf & strIn Loop Close FNum Set ol = New Outlook.Application Set mi = ol.CreateItem(olMailItem) mi.Display MyHtm = mi.HTMLBody ' or MyHtm = TheSig MyHtm = "<font size=""4""<font color=""blue""<b<font face=""Comic Sans MS""" MyHtm = MyHtm & "Hi " & ActiveCell.Offset(0, 1).Value & "," MyHtm = MyHtm & "</font</b</font" & TheSig mi.To = ActiveCell.Offset(0, 4) mi.HTMLBody = MyHtm mi.Subject = ActiveCell.Offset(0, 1) & ", " & ThisWorkbook.Sheets("Scripts").Range("b80").Value End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Excel 2002 Attachment from Outlook 2002 | Excel Discussion (Misc queries) | |||
Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Excel 2002 vs Outlook 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming |