Hello!
I'm a complete VBA newbie, and I'm attempting to create what is for me a quite complex macro for my bosses and I. I've already done the visual part of the report, but they also want the document to send emails via Outlook when any documents have their due dates expired. I'm on Office 16 btw.
In my mind, it would go as follows:
1. The macro would check in a range of cells (from F5 to N) if any of the documents are past their due date, whether by checking the date or seeing if the conditional formatting rules I've added (red filling, bold letters) affected any of these cells;
2. If true, the macro would collect the document number(s) from the cell(s) in column A to add onto the body of the email;
3. And then fill the "To:" field in the email with the owner of the document(s).
I also thought of an alternative in which they would hit a button to make this check, and it would prompt a box instead. If there aren't any expired dates, the box would tell them. Otherwise, it would give them the option to send via email the number(s) of the document(s) with any expired dates.
I've already searched the web for solutions, and I couldn't find anything. Maybe it's something very specific, so I'm hoping any of you guys can help me.
Thanks in advance!
Bookmarks