Loop through table and send individual report by email

Hello

I am fairly new to using access, what I am looking to be able to do is to based on a list in a table (Where Emails and names are stored) send a report as an attachment for each line in the table, I have been able to send the whole report as an email attachment but I am struggling to break the report down and send using the email address from the table.

would appreciate any suggestions

kind Regards

eagleadam89

build a form , put a list box on it. The query behind the list box shows all the emails., name,email
put a txtbox, (or combo) to pick what report to send
next, put a button which will scan the list and send.

select the report
click button , then all emails in list box will be sent the report via code below, in the btnSend_click event...

Please Login or Register  to view this content.