attachement

  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

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top