Dear sir, very urgent i want create & draft multiple mails in outlook with multiple attachment (contain specific unique word) using excel macro/vba suppose i have one folder of pdf file (pdf around 10 nos)= 1) out of which i have 5 pdf having different names but word "pvvp" is common in all those pdf's 2) & i have 5 pdf with different names but word "pvep" is common in that now i want write macro in which outlook mails should get generate with attachment names contain "pvvp" & pvep differently. So my question is how we can write macro that should search "pvvp" word in multiple pdf's names in that pdf folder & should attach only those attachment to mail that contain that "pvvp" word only ???? pls guide its very urgent
