VBA code to send email to the people whose email address is in the Access table

Hi All

I have specified the email addresses in the code to whom the email will be sent when the user presses "Send Email" button but now I want to add all the addresses in the Access table and write down the code that will send an email to those people whose addresses are in the Access table. Can anybody please change the code accordingly?

Please Login or Register  to view this content.

Hi Richard,

I am using Access as a backend and Excel as a frontend for my project. So I want all the addresses to be in the table of Access DB. and the code should send an email to the email addreses present in Access .

Could you please help me in this?

Thanks

ok. If I write the vba code that will fetch all the values from the Access table named tblemail and populate all the values in the sheet1 of current workbook and then read the cell values in the .To section .

Can you help me to write vba code for this?

Thanks

Richard, I got all the email addresses in sheet1 of the workbook . So now how to add all those email addresses in the .To section of Sendemail function.

Thanks for your help so far.