Outlook Forms and Access

aroth

Registered User.
Local time
Today, 06:25
Joined
Jun 18, 2008
Messages
12
I have a brain teaser for you guys:

Right now, I have a module in Access that creates and sends an email to recipients as they appear in a recordset. I'm using an Outlook form as the template for this message.

Code:
Set olObj = CreateObject("Outlook.Application")
Set olNS = olObj.GetNamespace("MAPI")
Set myFolder = olNS.GetDefaultFolder(olFolderInbox)
Set myItems = myFolder.Items
        Set myItem = myItems.Add("IPM.Note.Loss Run Request")

I published this form to my Inbox (not enterprise level as I don't have rights to do that, though I can get it done if it needs to be) and ran the code, sending the email to myself. When I do this, I can see the form and interact with it, but when I send it (via VB) to anyone else, they can't see the form. The weird part is, after I send it to myself, and I forward it to anyone else, they can see the form.

Why does this happen? Is there a way others can see the form when mailed from the code I wrote in Access? Should I change how the mailItem is created in the code, or is there a setting in Outlook that needs to be changed?

I hope this makes sense as I'm trying to simplify a complicated situation.

Thanks in advance for your help.
 

Users who are viewing this thread

Back
Top Bottom