Access Query result with Parameter email send to customers

[atuljadhavnetafim]

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.

Table "Customer_Master" has customer email address.

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

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

above data i want to send thru email and .To = Email_Address
in body paste this table in HTML format and send

I have tried many macros but that did't work from Accessforum

 

[welshgasman]

Crossposted at Email address from query table - Page 2

 

[welshgasman]

Also crossposted Get Email address from Query table to send emails

 

[atuljadhavnetafim]

Yes, it was posted twice earlier but post again due to solution not found,
i request experts to look in to this since i am not expert and not use to VBA, but i know this is very simple requirement and can be done.

please support

 

[alansidman]

Suggest you spend a few minutes and read this-->A message to forum cross posters

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
If you do cross-post in the future and provide links to all the other places you have posted the question to, then there shouldn’t be a problem.

Thank you.
The Moderators

 

[atuljadhavnetafim]

Thanks
this is cross posted on Get Email address from Query table to send emails and Email address from query table - Page 2
at Access forum also posted last version of Macro but it did not work properly,

Dear Expert please check both the link and see if you can help me for solution
the requirement with sample data paste in this thread also.

 

[welshgasman]

You also want to be careful where you do crosspost, as I know one member in another forum was banned because of it. They had been on the forum a good length of time, as you have been here, and should have been aware. I did try and plead their case, but that was rejected.

 

[atuljadhavnetafim]

Got it, thanks i will take care,
Now what should i do for my problem, should i close this thread or wait if somebody look at and resolve issue?

 

[welshgasman]

I have shown you how I managed to do it on the other forum?
I still recommend an attachment though, much easier to do.