email attachement

I have been using CDO to send emails for quite some time. I now have a need to attach a Powerpoint file and am unable to do so. I get a Runtime error '438': Object doesn't support this property or method when it reaches .AddAttachment. I have verified that the file I am passing...

Hi All, I am trying to do an automation of an excel emailing process. I have a workbook which as around 68 sheets in it. I have to send the sheets as attachments to multiple email IDs. The Email ID are in the A1 cell in each sheet. There are some sheets which needs to be sent to one email ID...

Hi all! I'm looking to use VBA to save a spreadsheet as a PDF and then automatically attach the PDF to a new Outlook email. The code below works fine for this, however only if the file is saved in the default location when the 'Save As' window pops up. If the user changes the folder into which...

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

Hi All, this is my first post. I'm really stuck on this one: I want my macro to find the biggest Excel file in a specified folder and its subfolders (say Music folder), then attach it to an email. Found this beautiful code made by Mohammad Basem on this forum: it checks the folder and list...

Hi, can anyone help me for the VBA code if this? I want to browse for a file (using a button) then place it on specific cell which is D3 then upon clicking Send button, it must create an email using outlook application with the attachment that i browse to the following recipients in C3. Thank...

I have 30 excel file saved on hard drive, and want to sent these file through outlook. every file will be sent on different email address. Please help

Hello helpful readers, I have a very lengthy and complicated VBA code that is currently running through the data entered on one sheet, compiling it on another and then formatting those results onto a mock paper print out that my company uses. What I need is to email those paper forms while...

Hello, I am using Excel 2010 The code below works flawlessly on the first time around: For I = 2 To Range("F" & Rows.Count).End(xlUp).Row .Attachments.Add Range("F" & I).Value Next I The second time around. It adds all of the rows from the first filter and the second, not just visible rows...

Hi, I'm using Excel 2013, Windows 8.1 I want to send just the excel sheet containing dashboards (many charts). Additionally, this excel sheet has to be saved as an image file such as JPG, since the recipients will be receiving the sent file through their phones. Also, is there a code for...

I can send my user form by e-mail, but I want to attach a Word file prior to the message being sent. The Word file is a requirement for me to process the form. How do I use VBA code to create a pop-up for the user to browse for the Word doc and attach it along with the worksheet in the same...

Hi, I want to create macro, which will be sending email with attachments. Sub create_email() Dim wb1 As Workbook Dim ws1 As Worksheet Set wb1 = ActiveWorkbook Set ws1 = wb1.Worksheets("row_data") '****************************************************** 'copy range Dim wb_e As Workbook Dim ws_e...

<tbody> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> column letters BA BB BC BD BE BF...

Operating System: Microsoft XP Applications: Excel 2007 Outlook 2007 I am trying to write a macro that would extract the data from selected msg file(s) within a folder and paste the data in to the next available row. I already have an existing workbook with data on it. It should look like...

Good Morning! I am currently attempting to use an excel macro to allow me to send a list of files to one person. I have managed to create a dynamic list where one sheet of the workbook has the list of files and checkboxes, and as certain ones are selected they appear in a list on the 'front...

I did this 10 years ago so I admit I am rusty at this but here are what I had in my notes that worked with Excel XP. I am currently using Excel 2010 With ThisWorkbook .HasRoutingSlip = True With .RoutingSlip .Delivery = xlOneAfterAnother .Recipients =...

Dear All, I am looking for a macro or add-in that will save an Excel sheet as a PDF and attach the PDF to an Outlook email. My idea is to have one sheet in the Excel file with a table of sheet names, recipient email addresses, subject lines for the emails, and customized messages for 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...

Hi All, I want send the a spreadsheet to several email participants. Currently I set the macro to send to just one person how can I build the macro to span the entire list. With OutMail .to = Range("I2").Text .CC = Range("J2").Text .BCC = "" .Subject = Range("L2").Value .Body = "Hi there"...

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