fluffy
08-02-2007, 07:21 PM
Hello World!
I'm using Excel 2003 in Windows XP to send emails of RFQs (Requests For Quotation). I can save each different RFQ, and then attach it to an email and send it. That works fine.
Now, I need to be able to add drawing files (1 or more) to the attachment list. The drawing/s are in PDF format.
If possible, I want to use "Application.FindFile" to open up the file search window. My thought is to use that window to select the file/s to add to the attachment list, but then (instead of opening them) to capture the list of selected files and transfer them to my attachments list.
Is there a way to do this?
Am I totally off-base here?
Is there a better answer?
Thanks in advance for any help you can provide.
fluffy
I'm using Excel 2003 in Windows XP to send emails of RFQs (Requests For Quotation). I can save each different RFQ, and then attach it to an email and send it. That works fine.
Now, I need to be able to add drawing files (1 or more) to the attachment list. The drawing/s are in PDF format.
If possible, I want to use "Application.FindFile" to open up the file search window. My thought is to use that window to select the file/s to add to the attachment list, but then (instead of opening them) to capture the list of selected files and transfer them to my attachments list.
Is there a way to do this?
Am I totally off-base here?
Is there a better answer?
Thanks in advance for any help you can provide.
fluffy