Hello All
This is my first post, this website has helped my many times. I have a code that i need emailed out every 30min and it is currently working fine it updates my worksheets and them pastes data into an email and sends it out. The problem is i cant get it to stop. I have another VBA that creates a query to a download link and then i just have to refresh all to update data. The link for the query only stays active for 24hrs so i have to change it everyday and then run the VBA to start the emails. The code is posted below i just need the emails to stop sending at 11:59pm on the day it is started or have it set only to run a certain amount of times and then stop. Any help would be greatly appreciated code is pasted below
Please Login or Register to view this content.
Thank you
Bookmarks