I have a table that has my email addresses, and I want to send individual reports to each email address. How do i have the "TO" field populate my email address and seperate each report?
I have a table that has my email addresses, and I want to send individual reports to each email address. How do i have the "TO" field populate my email address and seperate each report?
a form has a list of persons ID and emails.
a combo box with a report to send.
the query of the report looks at the listbox of IDs to pull only that persons data.
...select * from table where [id] = forms!myForm!lstEmails
a button to scan the listbox, select 1 at a time, email the report.
Yes, can use a listbox to select particular addresses. Or open a recordset in VBA and loop through records. Open report filtered to ID in record, send email with report pdf attachment via SendObject to the email address in record, close report, move to next record, repeat.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.