Automatically enter email address from customer table

[Pure Salt]

I have a query which opens an invoice report for the current record, I then click a button, select PDF & it is then added to an email.

Is there any way I can get the email address to be entered automatically? The email address is stored in my customer table.

[ItsMe]

My preference is to use VBA. Here is one approach using VBA.

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

[Pure Salt]

Thanks. Can I do that through a macro as I do not really have an knowledge of VBA?

[ItsMe]

You can build macros to send an email. I believe there is a way via an Email tool within the Ribbon. You can explore this method by clicking the "E-mail" tool under the "External Data" tab in the Ribbon.