Creating tools to perform some actions

20 pts.
Tags:
Microsoft Excel
Microsoft Excel files
I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task.
Kindly help.


Software/Hardware used:
excel and macros, java oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • okok
    Hi Kindly answer on how to automate mail service messages when referring to blank lines in the excel files?
    20 pointsBadges:
    report
  • TomLiotta
    Microsoft shows an example of sending e-mail by a VB macro in Excel in Sending Email to a List of Recipients Using Excel and Outlook. You should be able to adapt the functions in it for your needs. If not, you need training in Excel and Visual Basic, or you need to have a developer create the programming for you. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following