attach file

Hi All, I need to attach a series of PDF's to an Outlook item in excel. I have a command button which will open up a outlook message but I need to know how/where can I store the PDF files if I was to access the spreadsheet sung a dofferent machine that I do not have to change any folder paths...

This is going to be a long one. I apologize. I found some VBA script online (this is not something I wrote and can't take credit for any of it) that allows me to export and save the active range as a pdf and it automatically attaches it to an email with some predetermined verbiage. I have...

Hello there! 　 I have pieced together several macros and I am almost good to go with my project. However, the macro I need help with is the actual sending the mail. The script I found, would generate a pop up and could use that to enter in an email address. However, I'd like to remove the pop up...

Is there a function or command that will attach a completed worksheet as a file in an e-mail note when a hyperlink is on the worksheet with the mailto:anyone@hotmailcom filled in as the hyperlink? I'm trying to have a user complete a worksheet, click on the embedded hyperlink that opens an...

Hello all, My question has multiple parts to it. Basically, I already have my CDO code and functions that can send emails and attach a pdf of different sheets. What I am looking for is: a) a way to locate the file location that the current workbook is in. b) add that file location to my cdo...

Hi, I am running a Macro to attach the active sheet to an email as a PDF. I also want to be able to add another PDF from a network drive. I have tried to splice the code from another Macro I use to attach a specific file. 'Add the active workbook as an attachment OlMail.Attachments.Add...

Hi All, I have a spreadsheet with a user form on it for submitting requests to a helpdesk and attaching files. Ideally I would like to automate this as much as possible. So I would like a button on the form to bring up a Windows Explorer window to select a file then attach it within the...

Hi all, I have been using 2 of Ron De Bruin's codes to send emails with attachments from Excel. Actually they are great and working perfectly but I need to combine 2 of them so I would only send one email to each receipient rather than 2 emails one with external attachments and another with...

Hi, I'm not exactly sure what i'm doing. I need to make a 3-D formula to calculate the highest temp in the 3 different cities.. I'm completely lost when it comes to having to do more than 1 thing in a formula. Each of the cities are one in each of its own worksheet. I have to do a 3-D...

Hi all, How can I attach an attachment to and email using VBA. So I compose the email and want to be able to run the macro to automatically attach required file. The file address and name will be the same everytime? Cheers, O