Outlook Renaming PDFs Created From Excel WB

[motherteresa]

I recently purchased an HP laptop. I am running Microsoft Office 365 for business. I use some workbooks for clients that are VBA-heavy. One of the VBAs I employ prints out by clicking on a command button PDFs of the testing our company provides. Those PDFs are automatically saved into the same folder as the workbook. They are named in the following format:

Client Test Date (ie - ALL SAINTS SURGERY CHEMICAL 03.22.23)
When it comes time to send reports to the client, I click on another command button that creates an email in Microsoft Outlook, with the recipient email(s), subject, and body of the email. It also attaches select PDFs. Here's the problem...when the PDFs are attached to the email, the name is changed to include the %20 symbols in place of where the spaces were. So the above example becomes ALL%20SAINTS%20SURGERY%20CHEMICAL%2003.22.23...which is disastrous!!!

My secondary problem is that the VBA that attaches the PDFs was designed to only attach specific PDFs to the client email (ie - Only the PDFs that were created/printed) and to the home office email (the same, but with an additional Recap Invoice PDF). However, now if a PDF is NOT created/printed...it shows up as an attachment that says "download failed." It obviously failed because it's not in the folder. But why is it now showing up in the email as a failed download?? When I sent a test email to myself, that PDF that is not supposed to be attached IS attached, but with a d.docs.live.net designation. If clicked upon, it takes me to OneDrive.

I am going crazy!!! How do I stop all this from happening, please? I feel like this new laptop is possessed.

 

[motherteresa]

By the way, I learned just now that if I just create the email manually and copy/paste the PDFs, everything looks fine. The PDFs remain named as usual.