Hi everyone,
Under a specific file, for example Q:\Users\XXX\My Documents\File I have 100 excel files with different names.
I want to copy the first sheet of the excel file with a macro and send it to the contacts.
I can write the email adress a certain cell of the file or I can keep them in a list.
How can I copy-paste all the data in the first sheet of each file and paste it into the e-mail and send it immediately? Can you suggest a code for this?
Under a specific file, for example Q:\Users\XXX\My Documents\File I have 100 excel files with different names.
I want to copy the first sheet of the excel file with a macro and send it to the contacts.
I can write the email adress a certain cell of the file or I can keep them in a list.
How can I copy-paste all the data in the first sheet of each file and paste it into the e-mail and send it immediately? Can you suggest a code for this?
