E-Mailing A Report (From a form)

[adams.bria]

So I was wondering if anyone knew how to go about doing this:



I have a form where I assign students to an employer. I basically use a sub-form that collects the Id's numbers into one table. I then created a button that will launch a "Student Profile Report" using the record that I have selected. What I would like to do is e-mail that report as a pdf attachment to the students e-mail address. Any ideas on where to start? Thanks!

-Brian

[TheShabz]

Start here and let us know if you get stuck....

http://www.everythingaccess.com/tuto...curity-Warning

[adams.bria]

That takes care of the security... However I still don't know how to actuelly create the proccess of attaching the pdf and inserting the e-mail address of the current student record?

[TheShabz]

in:

'Create the recipients TO
TempArray = Split(strTo, ";")
For Each varArrayItem In TempArray

set strTo to whatever variable you have your email addy stored in

the attachment can be added via
Set objectlookAttach = .Attachments.Add("Full Path of File and File Name")
from
http://bytes.com/topic/access/answer...ment-using-vba