+ Reply to Thread
Results 1 to 2 of 2

Excel Birthday Auto Email

  1. #1
    Registered User
    Join Date
    03-22-2012
    Location
    bc, canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel Birthday Auto Email

    Folks
    This forum is just to cool. Though I do apologies to DGagnon for not understanding the Star concept as I hope I do now. I will pay closer attention.

    Windows 7
    Office 2007

    Query:
    I am the secretary for an Aviation Society and am attempting to construct a membership database (where Col b is the first name Col c is the last name etc) which includes birthdays in (Col. K).

    My query: Is there a formula which continually monitors Col K (Birthdays) and auto sends a birthday greeting email on the day of the birthday (possibly multiple emails) using the default email program to the named person in Col B and Col C? My office system has only Thunderbird on it.

    Thanks for this

    Der1

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Excel Birthday Auto Email

    Inregard to getting the e-mails to automaticaly send, you will need to set up a macro that you manualy run once per day. but for the details of sending an e-mail from excel without using outlook, check out this post

    http://www.excelforum.com/excel-work...underbird.html

    let me know if you have any questions, it is a VBA solution, and a bit more complex than the previous question you posed

    p.s. no need to appoligise there is no requirement to rep a post.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1