Dear Holger. We have one more requirement that , we have to send e-mail in 3 category’s
If the documents on hold 0-15 days
If the documents on hold 16-30 days
If the documents on hold more than 31 days
And also we have to include manger’s mail id in the CC, attached is the designed format , can you please provide me the program code for the same
Regards,
Hari
Hi, hariexcel1987,
is there any reason why there isn´t much of code in the sample (in fact just two brackets not filled with an code in Sheet "DISC"?
Use an Autofiölter on Column P in "Hold-Data", run the range of visible cells and have a Case Select for the text to be shown in the mail depending on the value from Column P - that´s the basic idea right now so that you will have to adapt the time range for the three macros but not the basic code to deliver the mails. If you prefer you could as well compose three nearly identical macros for each period, or use textfiles to hold the individual passages for the mail. You could as well step through all cells on Data-Hiold and compare P to the values for that period.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks