send form as an attachment

Khushalay

Registered User.
Local time
Today, 04:47
Joined
Apr 16, 2016
Messages
180
Hi friends

I have form where data in entered by data entry operators. For some reasons I need the current opened form to be send as an attachment in email. How to achieve this. Plz help me.
 
I have this code but this send all the 3000 plus forms.

DoCmd.SendObject acSendForm, "", "(*.pdf)", mailList, " emailaddress ", , subText, message, False


just want the active form to be sent as attachment.

Plz help me out.
 
Last edited:
I would send a report. You have a lot more control over the format, and it's easier to filter to the desired record. One way would be to base it on a query that had a criteria pointing to the form.
 
Someone please help me out in doing this. I can't achieve
 
Create a report that mimics your form.
Open the report filtered to your current form record. The easiest way to do this is put the forms unique ID in the criteria of the reports underlying query.
Send the filtered report exactly the same as you are sending your form.
 
Is there a way to create a report that mimics the form to the tee?? If yes, how to do that?

So thr is no way to send a current active form as an attachment?
 
Excellent - glad you sorted it out.
 

Users who are viewing this thread

Back
Top Bottom