Auto reminder mail in VBA based on data in excel

Jayant 0 Reputation points
2024-06-18T17:16:10.5433333+00:00

Hi,

i want to put a process ..we have formal RO process for radio industries.....when we don't have formal RO ..we book the deal and they promise to send formal RO in in a day or two....if we don't receive formal ro in a two days then we need to send a auto reminder mail to sales person regarding formal RO pending. we update daily excel sheet for that...but I want email to be sent auto. though .vba and database in excel sheet

Column Field is...User's image

i want to send automail with email is Dear Waris,

This is a reminder that the formal RO for RO ID %% promised on %% is still pending. Please send it as soon as possible.

Advertiser:

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,669 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,694 questions
0 comments No comments
{count} votes