I need some assistance please all.
I have around 100 excel files that need to be emailed out every 2 days.
I have just lost my admin resource and don't have time to do this manually.
Is there a way, using a defined address book or list of email addresses to create a macro that matches the email address to the file number and will send it automatically?
If not, can anyone recommend an alternative solution? (Pls don't say hire a new admin!!
Many thanks
Mich....
I have around 100 excel files that need to be emailed out every 2 days.
I have just lost my admin resource and don't have time to do this manually.
Is there a way, using a defined address book or list of email addresses to create a macro that matches the email address to the file number and will send it automatically?
If not, can anyone recommend an alternative solution? (Pls don't say hire a new admin!!

Many thanks
Mich....