attachments.add

  1. K

    Email attachment.add cell value runtime error 13 type mismatch

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

    Email attachment.add cell value runtime error 13 type mismatch

    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() ' '...
  3. J

    Email Attachment VBA Help!

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

    Use VBA to attach document from referenced cell to email through Outlook

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

    Macro send multiple pdf per mail.

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

    Multiple Attachments on Excel Mail Loop. Only Want One Attachment. Help!

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

    .attachments.add

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

    Adding Attachments with VBA

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

    Wild card VBA for file attachment

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

    VBA Type Mismatch 13 - WHat am I missing?

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

    Formatting across multiple columns

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

    Attach 2 or more email files

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

Some videos you may like

This Week's Hot Topics

Top