Access Code to Send an Email With Attachments

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Help!

I have written a database that uses one table whichcontains details
for each pupil at each school and one table that shows a list of the
schools and their unique identifier. At the moment, I have one report
with a filter applied - the filter being the unique identifier for a
school. I then have a recordset which is run via a button on a form
which runs through each unique identifier for each school and opens
the rpeort, saves it as a snapshot viewer file to a certain
directory. I reapeat this for another two reports so in the end i
have a folder containing three snapshot viewer files for each school.
Each report name begins with the unique identifier (called DFEE).

What i want to be able to do next is have a nother button on my form
which will run through a recordset for each school and send an email
to them with the three snapshot viewer files attached for that
particular school (which can be linked on the file name as the file
name begins with the unique DFEE number).

I know this is posisble due to several examples being posted on the
net but i cnat make any of them work. Can anyone help me get started
on this please?

Help very much appreciated.

Ta

Laura
 
Back
Top