Setting up an Email to automatically be sent based off a date
in [General]
|
From: jwebster1979 on 27 Apr 2010 19:22 I have a list of Birthdays were I would like an email sent automatically to my boss when it gets close to or on that day. I am not sure how to approach this. Any Suggestions?
From: Arvin Meyer [MVP] on 28 Apr 2010 15:08 "jwebster1979" <jwebster1979(a)discussions.microsoft.com> wrote in message news:A471D2D1-AF5D-42C4-8D06-BFFAA1F723A8(a)microsoft.com... >I have a list of Birthdays were I would like an email sent automatically to > my boss when it gets close to or on that day. I am not sure how to > approach > this. Any Suggestions? Use SendObject or the following: http://www.datastrat.com/Code/OutlookEmail.txt for the emailing. And something like this to get birthdays: http://www.datastrat.com/Download/Birthday2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access
|
Pages: 1 Prev: Using the DateDiff function based on 5 days Next: VBA Help in Access 2007 |