|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
June 9th 06, 02:24 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Early binding and late binding with attachment
Thanks Sue, problem solved
Cheers Jonathan Parminter "Sue Mosher [MVP-Outlook]" wrote: Have you tried using positional parameters rather than named parameters? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Jonathan" wrote in message ... Hi, in MS Access I have the following procedure... Set objMail = objOutlook.CreateItem(olMailItem) With objMail .To = BAE![aEmail] .subject = BAE![AnaesName] & "'s List" .Attachments.Add source:=strFile & ".doc", Type:=olByValue, Position:=1, DisplayName:="Booking List" .Display End With This works fine when the Outlook object library is referenced and each object is explicitly declared as the Outlook type. For example Dim objMail as Outlook.MailItem The problem is that at least one user does not have the same version of MS Office. So I cannot reference a specific Outlook object library and I declare each object variable as Object. For example Dim objMail as Object I declare each of the Outlook constants as constants. Const olMailItem As Integer = 0 Const olByValue As Integer = 1 The problem is that when declaring each object as object the line to attach a file no longer works. There is no error message and no attached file. Any ideas or suggestions that will assist me to use late binding are appreciated. :-) Many thanks Jonathan 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I get early birthday reminders? | T Perry | Outlook - Using Contacts | 0 | April 27th 06 07:04 PM |
| Item type numeric values for Outlook Late Bind | GeorgeMar | Outlook and VBA | 1 | March 20th 06 05:05 PM |
| Late binding sample | John | Outlook - General Queries | 3 | February 24th 06 09:32 PM |
| Late binding sample | John | Outlook and VBA | 3 | February 24th 06 09:32 PM |
| my appt. reminder is opening a day late. How do I change that | bg | Outlook - Calandaring | 0 | February 7th 06 04:51 PM |
Hybrid Mode
