Need a VBA to send the PDF copy from Folder through Outlook

[Vijethbangera]

Hi All,

I need help with VBA code to send the PDF copies from the folder through outlook using the Excel Distribution list that when I run, would look for the path, grab the file that starts with the client name/Invoice number in Col A, and attach to the email, along with a predefined message/header.

The distribution list has the following:


[TABLE="width: 677"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Client Name/Invoice number
[/TD]
[TD]Email
[/TD]
[TD]First Name
[/TD]
[TD]Last Name
[/TD]
[TD]Path
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]DEL100100XXX
[/TD]
[TD]vijethbangera@gmail.com
[/TD]
[TD]vijeth
[/TD]
[TD]bangera
[/TD]
[TD]C:\Users\vijetha.bangera\Desktop\ccc
[/TD]
[/TR]
</tbody>[/TABLE]



I would want the email heading to be “Client Name/Invoice number” (Column A) and to say something like Dear Team,
Find the attached invoice copy for processing.
Regards

More editable text.
Insert Outlook signature.

I have been looking around not found the way I want to generate and email pdfs from Excel .
However our invoicing system generates bulk pdfs which we have to save in specified folder like in a path above. So it should be flexible for me to put the path whichever I want and this should not be pre-fixed .So the Sheet one will be kind of data feeder .it is From A to E .We should be sending it one by one to the specified emails IDs . So I am hoping to automate the last step of this. Any help/tips would be greatly appreciated!.

As i have very little knowledge with macro i would like a completed file or a code to paste in module is desirable.
Regards,
Vijeth