attachment

Hi all, Hoping this is a simple fix. I have the below script that I found on another forum that runs as a rule in Outlook to save .pdf email attachments with a timestamp that come from my printer. That part all works fine. The problem I'm having is that it will save the file with the .pdf as...

I've an issue to export attachments from outlook to excel cells. The attachment is not the filename, but the file itself. For example, if PDF file, it will extract the PDF file to the cells, not the filename or the details inside of PDF. I know how to save attachment to the folder but not on the...

Hi, I am totally new to VBA but have been trying to piece together code to send an email to specific people based on non-numerical cell value, I have been all over the map, emails sending now they aren’t, but they were sending to everyone, not just the intended recipient, the attachment only...

Hello, I have looked through a few of the other threads for this but I have a command button that i want to display an email once the button is clicked. I kep getting an error that says variable not defined. Also in the second image, the two regions of vba keep getting highighted. Overall i am...

Hi All, Sorry if this has been asked already, If it has I've not been able to find it. I have a shared inbox in outlook that receives a mixture of emails with attached .csv files, I have built a macro to extract the .csv (if they match certain keywords), the macro then merges them into a...

I want to send different files for different people with Gmail using excel. Everything is well except when sending the attached items, it goes like this: Person A receives File A Person B receives File A and B Person C receives File A, B, and C it should be: Person A receives File A Person B...

Hi all, I need some VBA to allow me to send multiple emails (same standard email body but each with their own individual Excel attachment). I'm using Microsoft Outlook and Excel 365 Workbook Entitled: 'Raw Data' Sheet Entitled 'Sheet1' Column A: Email Address Column B: First Name (for email...

Hello All, Recently I have received some PDF files with XML attached. Of course when I double click on it it will open in a text editor. Cool. However. What I need to do is: 1) Open PDF 2) Extract XML attachment 3) Import it to a worksheet 4) Close PDF 5) Open another PDF 6) Extract XML...

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

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

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

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

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

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

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

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

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

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

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

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