Access Query result with Parameter email send to customers

atuljadhavnetafim

Active Member
Joined
Apr 7, 2012
Messages
341
Office Version
  1. 365
Platform
  1. Windows
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.

AR Table.JPG


Table "Customer_Master" has customer email address.

Customer Master Table.JPG


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

GetData2 Query.JPG


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

Query Result.JPG


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
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
I have shown you how I managed to do it on the other forum?
I still recommend an attachment though, much easier to do.
 
Upvote 0

Forum statistics

Threads
1,224,543
Messages
6,179,429
Members
452,914
Latest member
echoix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top