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

email from excel

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