I have created an elementary gradebook for my school district. After a teacher enters students grades, they want to be able to e-mail progress reports home to parents using Snapshot. Is there a slick way (VB or other) of completing the following:
1. Generate the report based on the first student in the list
2. Open the e-mail (Send to Mail Receipient (as Attachment))
3. Select Snapshot
4. Fill in the "To: " portion of the e-mail with the e-mail address that corresponds to the first student in the list.
5. Send the message with the attached snapshot.
6. Start again with the second student in the list.
Continue to loop through all of the students.
I know this is a lot and I can do it manually (much pointing and clicking). Any hints or pieces of the puzzle would help.
Thanks.
1. Generate the report based on the first student in the list
2. Open the e-mail (Send to Mail Receipient (as Attachment))
3. Select Snapshot
4. Fill in the "To: " portion of the e-mail with the e-mail address that corresponds to the first student in the list.
5. Send the message with the attached snapshot.
6. Start again with the second student in the list.
Continue to loop through all of the students.
I know this is a lot and I can do it manually (much pointing and clicking). Any hints or pieces of the puzzle would help.
Thanks.
