Email button on a form launching outlook

[chuchothelord]

I want to create a button on a form that will launch a new Outlook EMAIL using data from the current record.

1) I want to leave the "TO" field blank in outlook to be filled in by the user.
2) My database is basically a package log with simple fields... Package For, Package From, Date Received, Shipped Via and tracking number.
3) I want the Subject line to equal the "Package From" Field.
4) I want the body to be something like this... A package arrived for you on "Date Received" from "Package From". It was delivered by "Shipped Via" and the tracking number is "Tracking Number". Please pick up your package as soon as possible.



If this is possible, please let me know.

[ItsMe]

Here is one approach

Dim strSubject As String
Dim strBody As String
Dim strReport As String
Dim strTo As String
Dim strCc As String
Dim strBcc As String
strSubject = "Insert Subject Line Here"
strBody = "Insert text to be displayed in the email body"
strReport = "rptEquip"
strTo = "you@gmail.com"
strCc = ""
strBcc = "me@gmail.com"
DoCmd.SendObject acSendReport, strReport, acFormatTXT, strTo, strCc, strBcc, strSubject, strBody, False

The very last word in the example is False. This parameter is supposed to either send the email without the user reviewing it or open the object so the user can edit it and send it at their will. I can't remember if you want False or True. Having said that, some people complain that the parameter at the end (True or False) is ignored by some version of Outlook.

If you have to, you could try another method. One might be to create a Macro using the Email option within the Ribbon.

Another method is to instantiate an Outlook Object and automating. This requires a little more VBA.

Maybe something like this
https://www.accessforums.net/forms/c...tml#post225174