L
Lmanns
I'm stuck. I am trying to send a report via email by looping through a table
of email addresses but have not been successful after digging through the
boards. Would someone be able to help me, PRETTY PLEASE? This is the last
thing I need to do to have this database released to the users.
Here are the details:
qry1stNotice has a field BRANCH and other fields that explain the activity
for the specified branch. The query is based on tblLog. I didn't use the
table for the report because the query has criteria for what needs to be
escalated to the branch.
tblEmailAddress has the fields BRANCH, EMPLOYEE, and ADDRESS (address is the
email address)
rpt1stNotice is a filtered report by branch and is based on the query
qry1stNotice.
A branch can have multiple employees.
The end result is that I want to click the command button on a form to
generate the email with one email per branch, and attach the report in
snapshot form for the branch. I know it can be done based on comments in the
threaded discussions. I’ve not had success with any of the code I’ve found
in the threads because I’m still a novice with code and honestly, just not
sure what to change and what not to change to match the fields I have in my
report and query.
I’m using Access 2000. I hope I've provided all the info needed. Oh, it
would help, I have some code that I found on another thread that could
probably be tweaked if I knew what I was doing. It's a little long but I
will gladly post if it would help. Any help would be greatly appreciated!!
~Lmanns
of email addresses but have not been successful after digging through the
boards. Would someone be able to help me, PRETTY PLEASE? This is the last
thing I need to do to have this database released to the users.
Here are the details:
qry1stNotice has a field BRANCH and other fields that explain the activity
for the specified branch. The query is based on tblLog. I didn't use the
table for the report because the query has criteria for what needs to be
escalated to the branch.
tblEmailAddress has the fields BRANCH, EMPLOYEE, and ADDRESS (address is the
email address)
rpt1stNotice is a filtered report by branch and is based on the query
qry1stNotice.
A branch can have multiple employees.
The end result is that I want to click the command button on a form to
generate the email with one email per branch, and attach the report in
snapshot form for the branch. I know it can be done based on comments in the
threaded discussions. I’ve not had success with any of the code I’ve found
in the threads because I’m still a novice with code and honestly, just not
sure what to change and what not to change to match the fields I have in my
report and query.
I’m using Access 2000. I hope I've provided all the info needed. Oh, it
would help, I have some code that I found on another thread that could
probably be tweaked if I knew what I was doing. It's a little long but I
will gladly post if it would help. Any help would be greatly appreciated!!
~Lmanns