If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Emailing a form as an attachment
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 |
#2
|
|||
|
|||
Emailing a form as an attachment
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 ",,,"YourEm ailSubject",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/lib...ageusingaccess) Here are a few other postings on the subject to checkout: http://www.microsoft.com/communities...r=US&sloc=&p=1 http://articles.techrepublic.com.com...7-6160599.html http://www.utteraccess.com/forums/sh...Number=1624036 http://www.utteraccess.com/forums/sh...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. "Linda" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|