johnske
01-02-2005, 12:38 AM
Hi,
I have a main Excel workbook that I want to copy a sheet from and put in a new book - deleting the other 2 sheets in the new book.
That's pretty straight-forward, no help needed there...
But now I want to run a procedure in the main book that basically runs when the user clicks "submit by email" (the email address will be in a cell in the main book).
The procedure then has to send an email with a set message such as "submission for..(someone) dated..(a date) , but I also want this new (one worksheet) book sent as an attachment to the email.
I know absolutely NOTHING about Outlook - I had a look, but couldn't see any way to manually record a macro to do this - but anyway, I dont know if the end-user(s) normally use Outlook, Outlook Express, or whatever to send anyway...
So - where do I start???
TIA
I have a main Excel workbook that I want to copy a sheet from and put in a new book - deleting the other 2 sheets in the new book.
That's pretty straight-forward, no help needed there...
But now I want to run a procedure in the main book that basically runs when the user clicks "submit by email" (the email address will be in a cell in the main book).
The procedure then has to send an email with a set message such as "submission for..(someone) dated..(a date) , but I also want this new (one worksheet) book sent as an attachment to the email.
I know absolutely NOTHING about Outlook - I had a look, but couldn't see any way to manually record a macro to do this - but anyway, I dont know if the end-user(s) normally use Outlook, Outlook Express, or whatever to send anyway...
So - where do I start???
TIA