Email with multiple attachments

Hi,

I have been using some CDO email code for a while now, but I have only ever needed to attach 1 file.

For my current project I need to send upto 3 attachments.

The first depends on if there is a file path in name range "PDESC" and the other 2 files are the activeworkbook, which is saved in a folder called STAFF CHANGES BACKUP on the desktop, along with a word doc with the same file name as the active workbook found in the same folder.

So there should always be 2 attachments but occasionally there should be 3. Another problem I noticed when just testing the attachment who's file path is in range PDESC is that if the field is blank it creates a blank attachment which I don't really want.


Any ideas?

Here is my email code:

Please Login or Register  to view this content.