Can Excel can send automatic Email using Outlook?
Dear Friends,
i am very new to this forum, and i joined this to get my Excel skills better and sharpen...
i have a query... currently i am working on preparation of one mastersheet to track the project... and i am stuck at one place my question is..
if the cell A value is 5 and cell B value is 4 or 7... so if the cell value in cell C comes 1 then its ok(nothing req) but if the cell value in C is -2(negative).... then is it possible to send automatically Email using outlook... and how?
see if it helps you,
http://www.excelforum.com/excel-gene...coming-up.html
just change the line in red
[code]
'
'
For i = 4 To Sheets("Calibration due").Range("c65536").End(xlUp).Row
If Cells(i, 3).Value < 0 Then
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
'
'
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
John,
i am sending you my problem in attachment, it will be highly appreciable if you can help me out.
see the file attached, hope it helps you!
i have one problem in excel
i want to input the details below in each row
branch,product,process,customer,reference,amount,problem,email,cc email
what i want to do is immediately after inputting the above said details in excel row and pressing a button
can the excel automatically send a mail to the email id's i selected even the cc needs to be marked and the body needs to be the data i entered in the row of the excel
is it possible
can any one help me out
nagendraprabug, welcome here!
you know, the rule is to open your thread....
sorry john
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks