attachment

  1. F

    VBA send email to 3 addresses in 3 different cells

    I have a code that sends an email with attachment. Each attachment needs to go to 3 different addresses which are in 3 different cells. I can get it to send to the address in column K, but I need it to also send to L and M. Here is the code I have so far. I'm not sure how to add multiple...
  2. L

    Excel Send As Attachment Menu Option

    I have some code that I have put in Workbook_AfterSave and Workbook_BeforeSave. It works great and does exactly what I want; however, during testing, I found an odd situation where Excel doesn't call these two functions when saving a document (maybe Excel is disabling events on its own here)...
  3. L

    Cannot find contact for administrator to request attachment function

    Hi All Cannot find contact for administrator to request attachment function I need to send an example of Monitoring form in Excel as an attachmentfor my power bi Question. Could I please get rights for this as it statescannot send attachments? Any help be appreciated ? Thank You Leicester...
  4. K

    Export Email Data from Outlook to Excel

    Hi, I have this below code which works perfectly fine. I need help to achieve 3 more tasks. 1. The number of attachments should not count if the file extension is png 2. The files with extension png should be shown or exported 3. Is there a way that the attachment(s) itself can be...
  5. V

    Download Attachments from outlook

    I just want to give a path to download the attachments, but no success, It is now a hell of the code. is always opening the browser folder which should not be the case. it should directly download the attachments in strPath. "strPath" its not working, Code strPath =...
  6. S

    VBA code to remove attachments

    Hello, Can anyone help me with some VBA code that will remove attachments from a generated email? When I've looked online I've found examples that run in Outlook through an inbox but I have a Macro on an excel form that automatically generates an email and because I've used .HTML body to...
  7. U

    VBA to email selected range in body of email and add the same selected range as an attachment

    Hello! I'm hoping I explain this correctly but what I'm trying to do is use vba to send an email where the selected range is added to the body of the email and at the same time add the same selected range as an attachment to the email. I'm currently using Ron de Bruin's "Mail Range/Selection in...
  8. Y

    Outlook VBA: Save attachment, open excel, run a macro and resend out as an attachment

    Hi, I am still relatively new to VBA coding though have been running files with inbuilt macros. As my knowledge is limited to using existing codes and modifying from there, I hope fellow members in this forum can guide me through my issue below. I am trying to complete a VBA code in Outook -->...
  9. R

    VBA to check for PR SAP attachment

    Sub teste() Set SapGuiAuto = GetObject("SAPGUI") Set SAPApplication = SapGuiAuto.GetScriptingEngine Set SAPConnection = SAPApplication.Children(0) Set session = SAPConnection.Children(0) session.findById("wnd[0]").maximize...
  10. R

    VBA to check SAP Purchase Requisition attachments for Service

    Guys, I am struggling with this.... I am trying to check if there are attachments in PR for service, but I can only check if my macro click to open the attachment table. In some cases, when there are not attachments, the SAP crashes because the macro opened the table where wasn't able to open...
  11. M

    VBA Coding + Emailing Attachment via Outlook

    So I am fairly new to VBA Coding. Basically what I am trying to do is send my current workbook as an attachment via Outlook and I am wanting to have the subject line of the email be a specified cell range like I want it to be E3+D9. And also when sending the workbook as attachment is there a way...
  12. K

    Duplicate Attachment when Sending Email using Gmail in Excel VBA

    What I am trying to do is to send multiple emails to multiple clients with a click of a button, with each client has a different attachment. I can already send an email with an attachment, however, the second recipient also received the previous attached file sent to the first client prior to...
  13. J

    VBA to attach file and send to multiple recipients and then loop for a list

    Hello I am trying to get VBA to create an email, add a 'To' address, a 'Cc' address, attach a file based on a file path and loop through a list to create an email for every row in a list for different people with unique files. For example <tbody> To Cc Bcc File Director@company1.com...
  14. D

    VBA saving attachments from Emails

    Hi Guys, I've made a folder that collects hardware lists from the emails and then a macro that saves the attachments to a desktop folder but I'm trying to filter out all the jpeg's etc so that it only exports the PDFs, even better if it only gives the Hardware list PDFs...
  15. J

    File Location No Longer Displayed Under File Name on File/Info Page

    Morning, I'm hoping the title of my post explains my questions. If not, maybe my attachment will. In short, on older versions of Excel the location of the file used to be displayed under the file name. Knowing that helps me to decide if I want to click "Save" or "Save As". Small issue, but...
  16. T

    Sending excel file through outlook365

    I have been using an Excel-based form for years with a macro button that automatically sent the form as an attachment in an email through Outlook. Locations that have since switched from Outlook to Office365 say the button no longer works. Does anyone know where I can find the macro...
  17. C

    Merge email with excel list AND add an attachment

    Looking for VBA code to run a merged email to recipients listed on an excel spread sheet that has email addresses, first names and last names. I want email address in the BCC outlook field and first name and last name in body with the rest of my text. The clincher is how to add an attachment...
  18. D

    Attach a file to an excel addin

    I need to include an xslt file in my Excel Addin so that I don't need to send the file separately when I give the addin to other users. Does anyone know of a way to do this?
  19. V

    VBA to pull emails from outlook

    Hi all, Need help on macro to pull information from outlook. I have gone through the previous threads but not able to customize the solution to suit my need. I have taken the code / file from following link "https://www.vishalon.net/blog/expor...-meta-data-into-excel/comment-page-3#comments" and...
  20. Y

    EXCEL VBA MACRO TO email SHEET AS PDF ATTACHMENT

    I want to do as the title states. Print a certain range as pdf and send as attachment with a choice of a body. Can someone help me ? Thanks YM

Some videos you may like

This Week's Hot Topics

Top