Emailing a form as an attachment

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hi,

I have a form that our users fill out and then will have to email. RIght
now I only have one object on the form emailed to me. But I would like the
whole form to be emailed to me for that current record. Is there any way of
doing this?

Thanks
Linda
 
You could build a string based on the form controls and use the SendObject
method to email it.

For instance

sbody=Me.ControlName1 & vbcrlf & vbcrlf & Me.ControlName2

DoCmd.SendObject
acSendNoObject,,,"(e-mail address removed)",,,"YourEmailSubject",sbody

or an alternative would be to create a report based on the form, print it to
a pdf (using lebans rpt2pdf http://www.lebans.com/reporttopdf.htm) and then
email that using Outlook automation (see
http://msdn2.microsoft.com/en-us/li...odc_ac_olauto_sendanoutlookmessageusingaccess)


Here are a few other postings on the subject to checkout:
http://www.microsoft.com/communitie...978-87f0-2459ffa1226a&lang=en&cr=US&sloc=&p=1
http://articles.techrepublic.com.com/5100-10877-6160599.html
http://www.utteraccess.com/forums/showflat.php?Board=83&Number=1624036
http://www.utteraccess.com/forums/showflat.php?Board=83&Number=1216322
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.
 
Back
Top