attachement

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 =...

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...

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...

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...

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...

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...