obriensj
02-15-2010, 03:23 AM
Hi,
Not sure if this can be done.
I would like some sort of macro that enables me to browse out and attach say 30 excel files and send in one email, (outlook).
For instance I would have folders stored here:
C\Daily reports\final\report5.xls
C\Daily reports\provisional\day1.xls
I need to be able to pick up the “report5.xls” and “day1.xls” and the other 30 or so xls files and attach in one email.
I would also need the email addresses hardcoded in the macro so its sends to same list of recipients every day. There could be over 20 email recipients.
Is this possible as it is quite a manual process for me browsing out and adding every attachment?
Any help appreciated.
Thanks
Not sure if this can be done.
I would like some sort of macro that enables me to browse out and attach say 30 excel files and send in one email, (outlook).
For instance I would have folders stored here:
C\Daily reports\final\report5.xls
C\Daily reports\provisional\day1.xls
I need to be able to pick up the “report5.xls” and “day1.xls” and the other 30 or so xls files and attach in one email.
I would also need the email addresses hardcoded in the macro so its sends to same list of recipients every day. There could be over 20 email recipients.
Is this possible as it is quite a manual process for me browsing out and adding every attachment?
Any help appreciated.
Thanks