ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   e-mail excel files from a folder (https://www.excelbanter.com/excel-programming/413819-e-mail-excel-files-folder.html)

CAM

e-mail excel files from a folder
 
Hi,

I have a folder that contains about 25 excel files. The file name are based
on the managers name (i.e. "Robin Smith") etc. from different departments.
What I want to do is to have some way of e-mailing only selected "managers",
within the folder and I would like to use the same subject area, message for
all to be e-mailed. I don't want to type the same subject and use the same
message over again for all the files I selected. Is this possible? I am
using Ooutlook 2007, any help will be appreciated. Thank you in advance.

cheers


Ron de Bruin

e-mail excel files from a folder
 
Try this
http://www.rondebruin.nl/mail/folder2/files.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CAM" wrote in message ...
Hi,

I have a folder that contains about 25 excel files. The file name are based
on the managers name (i.e. "Robin Smith") etc. from different departments.
What I want to do is to have some way of e-mailing only selected "managers",
within the folder and I would like to use the same subject area, message for
all to be e-mailed. I don't want to type the same subject and use the same
message over again for all the files I selected. Is this possible? I am
using Ooutlook 2007, any help will be appreciated. Thank you in advance.

cheers


CAM

e-mail excel files from a folder
 
I will give it a try Ron thanks.


"Ron de Bruin" wrote in message
...
Try this
http://www.rondebruin.nl/mail/folder2/files.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CAM" wrote in message
...
Hi,

I have a folder that contains about 25 excel files. The file name are
based on the managers name (i.e. "Robin Smith") etc. from different
departments. What I want to do is to have some way of e-mailing only
selected "managers", within the folder and I would like to use the same
subject area, message for all to be e-mailed. I don't want to type the
same subject and use the same message over again for all the files I
selected. Is this possible? I am using Ooutlook 2007, any help will be
appreciated. Thank you in advance.

cheers




All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com