Sending a Form via E mail

[BobChesh]

I am trying to send a form, containing the details of one record, via E mail (using the do.cmd.SendObject, acForm, ACFormatHtml etc etc)

The problem is that when it is received, it is in datasheet view, and contains all the records, rather than just that conatined in the form.

How can I send a form so that it only sends the record in the form, and the format is more like a report, with the Field Names and contents going down the page rather than across.

Thank you in anticipation.

BC.

 

[mp9]

Create a report based on a query that identifies just the record(s) you want to send (you could use a parametised query to do this).

Then e-mail the report rather than the form.

http://www22.brinkster.com/accessory/

 

[BobChesh]

Great,

As I was playing about with this, I came to that conclusion, but I was hoping it would be simpler.

Guess not.

Thanks anyway for the very quick and useful reply

Bob