Bump no reply.
Now i m more explain you :
I have using excel 2003. Attach different file for your info.
I want to forward file address "to" & also copy mark to others "cc". In below code only address "to" write.
Range from column "b" to "e" but only those which display date. If in column "e" only 1 date show then only those range creat in body of mail. If more date display if display 4 or 5 date then all those display date range at a glance send by email.
Mail send before 5 days of visit date and continue send upto on visit date.
If today is 26 april 10 & in file only one date show 01 may 10 then mail send on date 26 april 10, next day 27 april 10, 28, 29, 30 april -10 & 01 may 10 on date mail send.
I have created code as per below :
Bookmarks