attachments.add

Hi all, The goal of the script is to display an email containing one or more attachments and a screenshot of the details of such attachments for each one of the clients within a column. The attachments tend to be Invoices and a single customer may have one or multiple. As of now, I have the...

Hi! I would like to attach different types of file to my emails. This code worked well and sent emails untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this...

Hi! I would like to attach different types of file to my emails. This code worked well untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this? Sub Send_Mail2() ' '...

Hi all, I have the below vba code from www.rondebruin.nl. However I would like only to have the FileCell.Value to be the filename, and have have the File Path and File Extension hard coded into the VBA as this will never change. Is there a way to do this? Thanks for your help, here is the...

Hi guys, I am trying to send an email automatically from excel 2013 using VBA, the email is successful, however, I am having trouble getting it to attach a document from a referenced cell. I would like it to attach the document that is linked into cell B9. The following code is what I have...

Hi all, The macro is as follows: a sheet is made and then saved as xlsx and pdf. Then outlook opens and set (only) the pdf as attachment. However i have more then 1 attachment. So the first 1 is made of an excel sheet and autopasted in the new mail. Te rest are manuals and are already in PDF. I...

Hello there! I have created a macro which will create a draft email and save it, with an attachment, in a specified folder. This has been looped in order to recreate this process a few hundered times if necessary. The macro works well with the first email however when it goes to attach the...

Hi, I have created a command button to communicate the status by sending outlook email with attachment and the attachment will be added by the user, some times attachment may not be necessary. When i tried with the following code it throwing an exception Path not found. eattach =...

Hi All, I'm somewhat new to VBA so bear with me. I'm trying to use VBA to automate emails with personalized attachments for each person. To do this, I created an excel spreadsheet with the person's name in the first column, email address in the second, and path to the attachment in the third...

Hi All, I found this bit of code on the internet (thanks ron) to send an email from Excel and attach a file. This works fine when I specify the path and file name (cell C16). In C16 I'll have the following 'Z:\ISB Data\Data Request Documents\Email files\Text.xlsx'. I have tried having 'Z:\ISB...

Ok - So, I posted about an error I was receiving related to the Outlook call a while back. I went around that completely and am just going to use SMTP to send an email directly (very similar to vbs, with obvious modifications for excel execution). I am getting a type mismatch error when...

Hi Guys, My question is difficult to explain and I have just realised that I can't post attachments or images on the forum, is there any way around this, as without a sample spreadsheet I don't know if I can get my question across clearly Phil

I have successfully created the vba code to attach a file and send an email. However, when I try to attach a secon file using a second .Attachments.Add sFileName , it simply replaces the one attachement with the second one and only has one attachment. I have seen places where comments were...