- Local time
- Today, 14:57
- Joined
- Aug 30, 2003
- Messages
- 36,125
Wondering if I have a version issue or something. The following snippit from a larger sub works great on my development machine, Access 2k & Office 2k. I get a type mismatch error on the set MyMail line when it runs on a PC with Access 2k Runtime and Outlook 2003.
Any thoughts would be appreciated.
TIA
Code:
Dim MyOutlook As Outlook.Application
Dim MyMail As Outlook.MailItem
Set MyOutlook = New Outlook.Application
'Type mismatch occurs on this line
Set MyMail = MyOutlook.CreateItem(olMailItem)
TIA