DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Want to send out alerts by using Excel

  1. #1
    Join Date
    Jan 2007
    Posts
    3

    Want to send out alerts by using Excel

    Hi Guys,

    I have an Excel spreadsheet at work which will be used to assign jobs to my colleagues. I want to have Excel send alerts to the my colleagues, one person at a time when it is that individuals turn to work on a task assigned in the spreadsheet.
    May I know if this can be done in Excel or not. If not, with what application can I use to trigger the alert messages.

    Thank you
    Last edited by frandeg1; 04-19-2007 at 12:35 AM.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Do you mean like Emails to these individuals?

  3. #3
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    Well you would need some kind of criteria that would execute the transmission of the email.

    But in addition you could send them an email with a worrkbook attached easily with one line of code:

    Code:
    Application.Workbooks("Book1").SendMail "meow@example.com", "Spam - Meow!", True
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

Similar Threads

  1. Replies: 12
    Last Post: 03-09-2010, 10:51 AM
  2. Need Code to send mail from Excel File
    By vks_online in forum Java
    Replies: 0
    Last Post: 03-20-2006, 11:29 AM
  3. Replies: 0
    Last Post: 03-09-2006, 09:40 PM
  4. ANN: Active XL Report 4.0 - Excel reporting with practically no coding
    By Afalina Co., Ltd. in forum vb.announcements
    Replies: 0
    Last Post: 04-01-2002, 10:39 AM
  5. Replies: 0
    Last Post: 03-19-2002, 04:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center