• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

email from excel


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


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
1 Solution
Naresh PatelTraderCommented:

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

& you have to change some part in VBA Code.

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

        '<<<<< Change to suit user >>>>>>
        myServerUserName = "xyz@gmail.com"
        myServerPwd = "123"
        '==== end change zone ====
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now