Macro for Email Wizard Using the Access Runtime?

[MFriend]

Hi Folks:



I have developed a table/form for tracking folks I want to email.

Is it possible to create a runtime that will allow me to access the "Create Email" wizard which is found under the External Data tab?

I can do it with no problem using the full version of access 2010. When I export the runtime, it of course does not have the menu available. I tried using one of the built in Macro's attached to a button, but it did not work.

Any ideas?

Thanks,
Matt

P.S. I just need the emails from one of the fields in my query to be added to Outlook in the BC or CC field.

[NoellaG]

Hi,

here you have some simple code to create an e-mail you can call from the onclick event of your button:

Public Function CreateMailMessage(strTo As String, strSubject As String, strBody As String, strFile As String) As Boolean
On Error GoTo Err_CreateMailMessage

Dim appOutlook As New Outlook.Application
Dim msg As Outlook.MailItem


Set msg = appOutlook.CreateItem(olMailItem)

msg.To = strTo
msg.Subject = strSubject
msg.Body = strBody
msg.Attachments.Add (strFile)
msg.Display

CreateMailMessage = True

Exit_CreateMailMessage:
Exit Function

Err_CreateMailMessage:
'MsgBox Err.Number & ": " & Err.Description
CreateMailMessage = False
Resume Exit_CreateMailMessage

End Function