Hi, i need a script that can pick out just a cell from a column in an excel sheet and email it to someone else given that there's no data on any cell in its row. Pls, can someone give dis a try
we are here to help you, not write it for you
do you want to do this from within excel?
if you search this forum you will find many examples on using CDO.message to send emails, in this or office development forums, you will find many examples on automating outlook to send emails
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Moved to the Office Development Forum.
Joacim Andersson
If anyone's answer has helped you, please show your appreciation by rating that answer.
I'd rather run ScriptBrix...
Joacim's view on stuff.
MVP
welcome to the forum,
see this link
Seenu
If this post is useful, pls don't forget to Rate this post.
Pls mark thread as resolved once ur problem solved.
ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms
Posting Permissions
Reply With Quote
