Am I understanding you correctly that you don't want the email to go out until 2 weeks later? I'm not sure if you're looking for code specifics, or thoughts on how to approach the task...??
If the database is used every day, you could do a search on the open of the database to see if any email reminders are due to be sent, and ask the user if they want to do it at that time. It could be a simple select query that looks for a date range. Add a field to the table that flags when it's done to avoid sending duplicates.
Create a recordset of the records to be sent, and then step through the records one at a time in VBA, using your send mail code. As you do the step through, do a record update to flag that the reminder has been sent.
One word of warning, though - later versions of Outlook (if that's the mail client you're using) will warn the user that emails are being sent, and will prompt for permission. I don't think there's an easy way to override that warning message.
If this is a multi-user database you might tie it into the user - kicking off the message only if it's user A (for example).
Just some thoughts...!
