Emailing an attached spreadsheet

try this, this should copy 2 sheets to a new workbook

Please Login or Register  to view this content.

the second sheet needs to be copied to sheet(2) not 1

you cant save the work book twice as different workbooks - delete this line

Please Login or Register  to view this content.

then delete this line

Please Login or Register  to view this content.

if you want to send 2 workbooks, you will need to copy the first sheet, save it as Customer Returns.xlsx
then copy sheet2 and then save that as Decontamination Certificate.xlsx

then you can add both workbooks as attachments to the mail.

Can anyone help with this?

Hi Sean Thanks for your help.

I ave done what you have suggested although i am unsure about the second post you sent regarding saving the workbooks. I am assuming you mean both files saved under different names.

I have tried all this and not the email function does not work. Something is happening but outlook is not opening a new email with any attachments.

Phil

Hi,
i have updated your workbook with some code i have used before.
This works on my pc.
You may need to change the name of the file you are saving the new work book as.
You cant save the new file as the same name as the one you are creating it from.

Should be ok

Sean

Hi Sean

i have tried this but all i get is the name decontamination certificate in the attached area but the attachment is the returns file. not sure what you mean regarding saveing as different name.

Thanks for all your efforts.

Sorry my computer crashed and i think it lost my version.
If i get a chance i will recreate it later. Had it all working nicely as well!!!

Hi,
I have recreated it.
Hopefully this is what you require.
it copies 2 of your sheets onto a new workbook, opens outlook, attaches it to a mail.

i have placed a few comments in the code to help you.

Sean

Hi, i have added some additional code to save 2 individual sheets as 2 new workbooks and add them as attachments in the mail. Just in case.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

outstanding
Thanks Sean