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.
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.
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.