e-mail send via a form

[Sparky]

I would like to have a button on a form, against each record that has been entered onto the form and once the button has been clicked on, an e-mail would be automatically be generated with the contents of particular fields and automatically sent to a pre designated e-mail address.

Is this possible, if so and help would be most appreciated.

Many thanks in advance

 

[maxmangion]

search this forum for DoCmd.SendObject

 

[ColinEssex]

Have you done a search yet? this is covered regularly.

There may be a sample (can't be 100% on that)

Col

 

[Sparky]

Yes, but doesn't seem to be anything that I am after.

Can you assist?

 

[ColinEssex]

Have a look here

Col

 

[Sparky]

Thanks Colin - that's great!

Will this tell me how to only send a particular record on the form instead of all the records.

I have managed to work out how to send all the records but I do really only need to send per entry in the table via the form?

Many thanks and very much appreciated on all your help