Microsoft Access 2007, Visual Basic & PDF Creator


I’m currently developing a small database where there is a button to pdf & email a report.

I want to develop the Visual Basic code so that it will automatically use PDF Creator to create the file and attach it to a new email.

Also, is it possible to fill in the “To” recipient automatically with the contents of an email field in the database?

Thanks, Colin