Hi everyone, i have been tasked at work with keeping tabs on vehicle road tax. I am a novice excel user and wondering if i may get some help in achieving what i am attempting. Basically i have a workbook with two sheets. The main, or front sheet has a table with a list of car, lorry and van registrations in one column and a column with tax due date. On the second sheet i have a column that has a date two weeks (today()-14) before current. I also have email addresses and messages in columns on this sheet. I am hoping i can get excel to send an email message to specified contacts whenever tax renewal is two weeks away, stating vehicle reg and a brief message. I would be most grateful for any help.
Bookmarks