Emailing Spreadsheets

[scouse]

I have to send out a spreadsheet to regional offices on which they will record work done under various headings.

All the headings will be the same (apart from the regional name on the top).

Is it possible for me to put a button into excel which the regions can click and will be sent to me email address?

To go further, is it possible for the spreadsheets to be automatically sent to me on a specific date without the need for a button?

Thanks in advance,
Scouse

 

[Glaswegian]

Scouse

Ron De Bruin has plenty of examples on this - see here.

Regards

 

[scouse]

Thanks,
there was a nice 2 lines of code which does the job.

Much appreciated,

Scouse