By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Sending specific reports via email automatically

P: 5
Hey everyone, hoping someone could lend me a hand here...

I'm trying to create a button in a form that will automatically send an email with a report. However this report can vary depending on the results you want displayed. When the form opens you need to fill a form indicating the supplier and client and date reange so the list of orders will appear. What I'm trying to do is have a SendObject action that will already have a To and Subject and everything but instead of being the same recipient and subject and cc all the time, I want to be able to input these every time I click the button. In other words have another little form pop up when I press the button to fill this information out. What code or macro could I write so that the To, Subject, and all those fill out according to a form? And is there a way to have access make a report in PDF format?? or just the usual excel, or RTF, or all the options it normally gives....

I would really appreciate some tips here and maybe an example of the code if possible.. thank you!
Jul 25 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
See this link for a free download demo mdb containing a form designed to send outlook email.

http://www.utterangel.com/utterangel.aspx#21

For pdf output see this link to Steve Lebans free Access to PDF converter if you have any Access version between 1997 and 2003. If you have Access 2007, pdf is natively supported.


http://lebans.com/reporttopdf.htm
Jul 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.