VBA issue: file not attaching in email

Hi

I have my code, where it saves a file based on username, in a specific folder, and then creates an email and attaches the filtered version of the file so i can send the email out.

this is my original macro:

Please Login or Register  to view this content.

I made some changes to my macro, added columns etc, and revise the code. for some odd reason, it's not attaching the file when it creates the email. it's creating the email in outlook perfectly, just not attaching the file anymore. Its showing the error as "error attaching file:[listed path] ---- see thread below for vba that is not working

No idea off the top of my head. I would try commenting out all the error handling and/or stepping through the code to see a) if it crashes and b) if it misses out any section of the code.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

In the original code, you set the file name early on to: fname = "C:\Users\john.smith\xx\Desktop\FP&A\Allocations\Test\Consolidated IES.xlsx"

In the failing code, you set the file name much later on: fname = "C:\Users\john.smith\xx\Desktop\Test\Consolidated IES_" & recipientName & ".xlsx"
where recipientName has been processed.

I'm guessing that line of code is either not executed, or the sanitisation has left something that shouldn't be there, or the code that attaches the file fails or isn't executed. Lots of options.

IMO, the only way to diagnose this is to switch off error handling and step through the code, checking the variabes and the route through the code.