Send query (Has parameter) result to Email address

[AtulJadhav]

Hi Expert

I have huge data with Invoice outstanding list, the other table has customer email information, by creating query and merge two table and filter only one customer at one time which has multiple line item, the result i need to send to customer email address as mentioned in customer master table in .To in html format.
here is the design

below is the "AR" Table, you can see each customer has multiple line item.
View attachment 80689

Table "Customer_Master" has customer email address.

View attachment 80690

have created query to get the data only for one customer which can be enter parameter [Acct_No].

View attachment 80691

when i open query, it ask me to enter customer code and it give me below data,

View attachment 80692

i would like to enter Account_Number code every time when i run the macro

and result i want to send thru email and .To = Email_Address (from query table)
in body paste this table in HTML format and send

I have tried this at MrExcel https://www.mrexcel.com/board/threa...th-parameter-email-send-to-customers.1214684/
and Access https://www.accessforums.net/showthread.php?t=86499

 

[AlanSidman]

Your attachments cannot be viewed. You will be better served attaching a file and noting the specifics

 

[AtulJadhav]

please find

 

[AlanSidman]

Here are a few tutorials on how to do this

MS Access Send query via email - Google Search

www.google.com

 

[AtulJadhav]

I had already referred lots of video and forum, but nowhere show if the query had parameter
you can check my cross post link where paste sample macro as well but that not working properly.

if you can see the link and suggest further

Thanks

 

[AtulJadhav]

any one can help on this