1. kpasa

    Userform TreeView - Drag and Drop files from Explorer and Outlook attachements

    I have a userform with a TreeView being used as a "Drag and Drop" file input. The goal is to have the userform automatically accept that file and copy it to a specified folder. So far i have this code in my userform_activate: TreeView1.OLEDropMode = ccOLEDropManual TreeView1.OLEDragMode =...
  2. F

    Macro to copy email attachments and paste data in exsisting wkbk in different tabs

    So I have a folder labeled "Weekly" with 6 different emails with "Scheduled Report" somewhere in the subject line. I need to create a macro that will copy each of those different sheets and paste them as different tabs in a specific excel workbook labeled "Revenue". I then wanted to label each...
  3. Z

    Email macro add attachement different file.

    Hey everyone ! I'm seeking your help because I can't seem to find a solution on the net. I use a macro to send emails automatically, and I need to attach a different file to the emails. The only way I found is to specify the file's location, however, since that file changes every week, I...
  4. A

    VBA code to convert excel to pdf and email it as attachment

    Dear Forumers, I really need your help. I am new to this whole VBA coding thing have no basic at all in programming and stuff so please help me out here. I am currently assigned a project where I have to create a excel sheet which act as a templete for sending request. The requirement of the...
  5. S

    Attaching a Spreadsheet

    I have code (see below) to send an email automatically if a button is pressed at it has been 30 days since the last time is was pressed. I am trying to attach the spreadsheet to the email but I am having no luck. This is the code I'm using: Private Sub CommandButton1_Click() Dim OutApp As...
  6. D

    Multiple email attachements based on variable value

    I need some help!! I declared 4 variables as string file1, file2, file3 and file4 then I assign the value of each cell to the respective value file1 = Cells(9, "C").Value ' Set the first file to attache file2 = Cells(11, "C").Value ' Set the Second file to attache file3 = Cells(13...

Some videos you may like

This Week's Hot Topics