How to attach a PDF to an email using VBA?

Hi all,

I hope you can help, what I'm trying to do is set up a sheet with a button that the users can press which writes an automatic email to our suppliers and attaches the relevant PDF drawing. I know how to do this by putting the reference in the VBA but the problem is that each job is different and I would like to automate the attachment of the relevant drawing.

I have written a concatenate cell which will automatically write the correct file reference for the job but pointing to a range when attaching doesn't seem to work. Any ideas how I can get round this?

Please Login or Register  to view this content.

This is what I want to do but it doesn't work

Any suggestions would be greatly appreciated.

Thanks


Moderator Edit:

Welcome to the forum, wattsup.

Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

Hi, wattsup,

maybe the code from Ron de Bruin can help with your problem - have a look at Mail a different file(s) to each person in a range.

HTH
Holger