Hi, i've researched my question, asked a different forum about it, but i need a way for Excel to automatically send emails in outlook based on due dates(reminder emails) in Excel. But i can't write VBA, and i'd have to teach my boss how to do this without it. Just wondering if there is a way to do this, maybe with a macro? So for ex: col A is the item, col C is due dates(i need a reminder email sent when [to]day is a week before the due date), emails are in column F. The reminder is just about when the product is due for shipping, to have it ready, etc. Maybe if there's an "IF" function? I'm totally stumped.
Thanks in advance for any help, tips!