Hello experts,
I have a macro that creates an email, attaches two excel files and all the pdf files in a specified folder.
The macro does not return any errors, but there are certain pdf files that don't get attached.
Those files have in the name "‐". This is not a normal hyphen. When I use...
I have a very simple code that I have created in outlook where the code will pick up an email template that was created, open it and add files to the email. I have the designated path for vba to pick and choose the file. My current problem is that sometimes the file in that path/folder may not...
folks,
some of my files are attaching and some are not. the macro below runs down a list and for every "Yes" in column F, create an email, and then add attachments. There could be 6 attachments at most per email. However, not every email will have all the attachments. The names of each of the...
Hello
I have seen different variations of this but I haven't been able to figure out how to make it work for me.
So I have a workbook that has many different variations of worksheets, each worksheet goes to a different store.
First a page would be saved as a pdf, with each PDF having specific...
I have successfully created a macro that upon clicking a submit button the excel file attaches to an email. It includes the To: email address and subject name based on cell content. I can not figure out how to also change the name of the file upon attaching.
Sub Submit()
Dim OutApp As Object...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.