Hello,
I am using the below code to automatically email excel reports via Lotus Notes and it works great. My question is that at times I will run this macro and there will be no report to send that day (an error obviously will occur as the macro cant locate the file). Is there an IF, THEN statement I can include in the code so if the file does not exist the macro should simply end? Any help would be appreciated. Thanks!
Please Login or Register to view this content.
Hi,
Try putting an 'Else' in the bit of code which attaches the file. e.g
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hello Richard,
I did as you said and it did not work. I get the below error message:
Run-time error '7225':
File G:\Share\Financial and Quality Control and Training\Reporting\Transfer Agency\Data Information\Processing Team 1.xls not found
Any additional thoughts?
Hi,
Sorry, my fault. I missed the point that the attachment is actually being predefined and that filename therefore always exists as a string but not necessarily as a file.
Try instead
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks