Attaching PDF files based on cell value

[Adnan_razaq]

Hi,

I have a spreadsheet which I will require to attach and send PDF files.

I need to create some functionality that a command button (or anything functional) will review a value of a particular cell and will attach the corresponding PDF files to an outgoing email.

For example, if a customer as a code of EUK ; they have requested for UK and European charts, therefore based on that I will need to attach the UK and European PDF files to an email and be able to send the charts to the customers email address which will also be in the spreadsheet, for instance in cell C5

Thanks in advance