send form as an attachment (2 Viewers)

[Khushalay]

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.

 

[Khushalay]

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.

 

[pbaldy]

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.

 

[Khushalay]

Can u plz guide me how to do that.

 

[Khushalay]

Someone please help me out in doing this. I can't achieve

 

[Minty]

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.

 

[Ranman256]

'already answered

 

[Khushalay]

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?

 

[Khushalay]

Ok got it and done successfully. Thanks

 

[Minty]

Excellent - glad you sorted it out.