email attachment loop

  1. A

    How to attach PDF file in excel thru VBA code

    Hi all, Just wondering how you can attach PDF file in email and send to the desire person via VBA ? I want to automate the remittance advice process. Much appreciated if anyone can help me with the issue. AZ
  2. P

    Emailing different attachments to different email addresses

    I am working on a spreadsheet that will send emails and their attachments to any vendor that has a "yes" in row H. The file path/name of the attachment is stored in row G. I can get it to work if I just do one at a time, but once I try to use a loop to generate all emails and attachments at...
  3. O

    Send Every Sheet in Workbook as Attachment to different Recipient

    Hello, I'm trying to build a code that sends each sheet in another workbook as an attachment via outlook. Each sheet to a different set of emails. Although I don't get any error message, the emails aren't sent. With my few vba knowledge I tried to work pieces of code I found. So I guess that...
  4. M

    Need Help with VBA for Creating Emails

    I am trying to create a macro that will loop through a named range that contains email addresses to create an email with hard coded subject and opening line of the body. I then need to insert a range of cells based on a named range into the body and then send the email. I have been able to get...
  5. P

    Macro to cycles through drop-down selection and send email with attachment

    Hello I have created a dashboard report that draws in various sources of information. This is tailored depending on the value selected in a dropdown (ie the lookups selection the appropriate information for that value). There are around 120 different options in the dropdown so in effect I...
  6. B

    Email Multiple Attachments

    Looking for a solution to email multiple files to multiple user based on a list of the following: Column 1 Filename / Column 2 Manager / Column 3 Email Address I want 1 email per manager. Set email for manager and attach applicable file. Help!
  7. B

    Group Email and File Distribution

    I am trying to write a macro which will copy a range of cells into an Outlook email and add an attachment which will be sent to a group of people on a distribution list, also included in the workbook. The code I am using is: Sub Cash_Email() Dim OutApp As Object Dim OutMail As Object...
  8. R

    Attaching Multiple Files to Email Document

    Using VBA and Excel, I am trying to attach multiple documents to an email. The user will input the file search criteria, and any documents matching that file search criteria will be added as attachments. Currently, my macro perform a file search and open a new email in Outlook, but I'm not...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...