email a form

[Sinnah]

Can I email a form as print out of a "current record form"?

I have tried the "send to" in the file menu,
but it only attached the table form of output.

Can anyone help me on this?

many thanks

 

[Atomic Shrimp]

You can email a form using 'SendObject' in VBA or in a macro, but it probably would be better to create a report that looks like your form and mail that.

Mike

 

[Sinnah]

Thanks Mike

I have not done SendObject from VB befor, I will give it a go.

If you have done it, sorry to be a pain, could I have the codes.

Thanks a lot.

sinnah

 

[Atomic Shrimp]

I've had a play with emailing forms and it doesn't seem to work very well, I think that any data in subforms is not included, and in any case, you'll have more control if you create a report and mail that.

I'll mail you an example of how to generate custom reports and email them.

Mike