+ Reply to Thread
Results 1 to 3 of 3

How do I enable Excel 2007 to send automatic emails to outlook

  1. 06-16-2014, 05:38 AM #1
    Joe McCabe
    Joe McCabe is offline
    Registered User
    Join Date
    06-16-2014
    Posts
    2

    How do I enable Excel 2007 to send automatic emails to outlook

    Hello, I am new to this forum so apologies is this has been posted in the wrong area.

    I am working on a spreadsheet that keeps track of upcoming contract and service renewals. Within the spreadsheet there is a column named "Status"; using a formula based on the renewal and engagement dates this column will automatically state one of the following -

    "Contract Status OK"
    "Up for Renewal"
    "Renewal Due"

    When I open the the file I would like excel to email 2 specific email addresses. The email should only contain data from the rows that state "up for renewal"; this email will act as trigger for my team to engage with the suppliers in question.

    I am not bad at using excel but I have no experience with VBA or Macro so I am not even sure where to start with this. Thanks in advanced.
    Reply With QuoteRegister To Reply
  2. 06-16-2014, 05:59 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: How do I enable Excel 2007 to send automatic emails to outlook

    HI

    Here is a good place to start with outlook

    http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

    If you've no experience in VBA, then you're asking a lot, i'd start off by learning on this one.

    So google loops in vba, reading excel contents vba.

    That will give you an understanding of what to do.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    Reply With QuoteRegister To Reply
  3. 06-18-2014, 09:26 AM #3
    Joe McCabe
    Joe McCabe is offline
    Registered User
    Join Date
    06-16-2014
    Posts
    2

    Re: How do I enable Excel 2007 to send automatic emails to outlook

    Hi

    I thought I might have been asking a bit much as I was unsuccessful in finding anything from standard web search...

    anyway thanks for the links.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to auto send multiple emails from outlook 2007
    By Jagdish Sharma in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-15-2013, 04:15 AM
  2. VBA code to send automatic emails via outlook based on deadline
    By Britny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2013, 10:08 AM
  3. Send emails through Outlook from Excel
    By fodster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2013, 11:16 AM
  4. Send outlook emails with message in cells to individual emails associated with them
    By abinayan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 06:11 AM
  5. [SOLVED] Can you tell Excel to send emails through Outlook?
    By Donald S in forum Excel General
    Replies: 1
    Last Post: 06-30-2005, 01:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1