Afternoon,
Can anyone please look at the attached workbook and figure out why the it won't send the email? (please ensure you change email address before testing). I have it working on another sheet but since I have added new columns (I have changed code to) it will no longer work, any help much appreciated.
Many thanks
Jason
Contract expiry test.v2.xls
Hi,
In your CheckForExpiryDates procedure you are passing the Column M reminder date as the first parameter in the Call SendMail procedure.
The Offset which sets the email should be 11 not 12.
Regards
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.
Thanks Richard......what an idiot, I've been staring at it that long I failed to spot a very simple mistake! Much appreciated....
Been there, got the T shirt.....many times
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks