VB code to change the subject name - Outlook

[Sam_D_Ben]

Hi team,

Need your help. Please check this sample file. Say for example; I am sending this file via mail to different agencies. See in this file sheet named base & column title Agency , filters concerned agency wise and send via outlook to the concerned agencies mail id from mailinfo sheet. What my concer is since these are different agencies, I wanted to bring the agency name in the mail subject. Hope this can ben done.

Link below:-

https://docs.google.com/file/d/0B48iYsjcqMEnUUpSNUZUVnd0Tjg/edit?usp=sharing

Thank You , Muz

 

[Sam_D_Ben]

Team,

Its ok, been done.

Thankx, Muz