Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() note: your code must compile without the outlook library: Just using CreateObject does not constitute late binding.. (although you need it) All variables must be defined as generic object variables. Dim outApp as object 'generic vba object Dim outApp as object All constants which would be provided by the outlook library must be defined inside your project or replaced with numeric value in the code.. for code to work with ol9 and ol11 you must check that you ONLY use methods/functions/procedures that exist in both versions. for normal development you'd need a machine with ol9. Create the code WITH the library. Ensure it works in ol9. Then edit code to latebound and remove the referenced library. then test it can compile. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Ron de Bruin wrote : Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strdate As String Dim wb As Workbook Dim ws As Worksheet Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up Outlook email? | New Users to Excel | |||
Outlook Email | New Users to Excel | |||
Email & Outlook | Excel Discussion (Misc queries) | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
Email from Excel WITHOUT Outlook | Excel Programming |