auto mailing with attachment

Hi friends,

I am very new outlook programming , i am think of automating few of my mails. i ahve folder in D:\Pdf where it contains lots of pdf with names , and fro that names , i have emails ids in excel . when could run a macro in excel can it refer to fiel name and pick the adress from the excel file and send the mail correspondingly , let me know whether this is possible.

format in excel
Sl No Producer Name To Mail address Cc Mail address
1 Ajgallagher [email protected]
2 Ajg-glendale [email protected]

if you see here producer name "ajgallagher" and my attachment pdf file will also have the same name

thanks in advance for your ideas

Hi,

under producer name you'll need to specifaid whole path, not just file name. As per bottom VBA ...

| SI No | Producer Name | To | Cc |
| 1 | D:\Pdf\Ajgallagher.pdf | [email protected] | [email protected] |

Please Login or Register  to view this content.

... play with this. You need to add Cc field. i'm using id directly in VBA. Hope this helps.


Cheers, Marko