How to attach excel file in outlook mail with conditions?

Does this work for you?

Please Login or Register  to view this content.

@ByteMarks

Many thanks for your response but I get the below error.

Sorry, I think there's a typo in the line above. it should be .xlsx not .xlxs

If it still fails, then you could try specifying the full path and file format, e.g.

Please Login or Register  to view this content.

Not sure why your Excel is crashing. I saved the code below in a module of an xlsm file and it works as intended. I.E., it attaches and xlsx copy to an email.

Please Login or Register  to view this content.

@ByteMarks

The above code works perfectly, without crashing I just need to check the dates on a Monday.

Just 1 request. After an excel file is created and renamed and before outlook is opened, can the file be saved to below location


C:\Users\rh294814\OneDrive - GSK\My Data\Others

Great.

You could try:

Please Login or Register  to view this content.

Perfect

Just that the file attached shows %20...% although file saved on local drive is correctly renamed.

What if you use

Please Login or Register  to view this content.

@ByteMarks

Sorry but may i know where to add it

If you replace the existing line in the part that creates the email.

Please Login or Register  to view this content.

Nope. Same error

Maybe save an additional copy to local temp to attach and then delete it at the end.

Please Login or Register  to view this content.

@ByteMarks

Working perfectly now. Thanks a ton.