Solved

email from excel

Posted on 2014-02-17
1
186 Views
Last Modified: 2014-02-22
Folks

How can I when a certain columns values get updated with the status "down" send an email out which copies that particular row's fields to a recipient

i.e.

item   url                        status
1      mysite.com            down
2      mypage.com            up

it should send an email to "Joe.blogs@yahoo.com"

saying subject "item 1 mysite is down"

only though when the status field gets updated(this is done by a maco(

all help will do



all help will do
0
Comment
Question by:rutgermons
1 Comment
 
LVL 8

Accepted Solution

by:
itjockey earned 500 total points
ID: 39866531
Mr.rutgermons,

I have already one file which perform this kind of process which is created by Rob so I don't want any credit or points. it is just sake of solution. Need any kind of modification then I cant as I am VBA coder.

here is short description of attached file there is 4 Columns.
A                            B                               C                               D
Item                      URL                           Status                       eMail
1                            mysite.com              Up                            --
2                            mypage.com            Up                            --
3                            myblog.com             Down                     myblog.com is Down

So in D column formula is like this
=IF(C4="Down",SendMail(B4),"--")

& you have to change some part in VBA Code.

SendBuy
    '<<<<< Change to suit user >>>>>>
    addressFrom = "xyz@gmail.com"
    addressTo = "abc@gmail.com"

SendMsg
        '<<<<< Change to suit user >>>>>>
        myServerUserName = "xyz@gmail.com"
        myServerPwd = "123"
        '==== end change zone ====
Thanks
Send-mail-V3.xlsm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now