Email Spreadsheet with subject line filled out from Cell contents.

[FountainsWill]

Is there anyway this can be done using a button in the spreadsheet please?
For Example.
I send numerous almost identical forms to a colleague and to eliminate subject line typo's (Reference numbers) i would like the Subject line to match a cell in the document itself.

I have experience in working with Excel, but none on using code/macros

 

[Maheshp]

Hi

Check whether this helps

http://www.rondebruin.nl/sendmail.htm

 

[FountainsWill]

Thanks for your help, i will have a play