Workbook contain auto Open Macro - mail sending code exist
hi
i have one data file with one macro. now from this macro auto mail send to user when contract going to expire.
now i want if user is same and his more then one aacounts going to expire in this case mail should be like
Dear
The Below contract is due for notice of renewal/termination in 30 days.
Contract Number
Supplier Name
Description
Type
Contact Start Date
Contact End Date
Notice Period
1
Service
01/11/2012
31/03/2014
90
4
Service
01/10/2010
30/09/2013
120
5
Service
01/03/2011
28/02/2014
30
35
Service
01/01/2009
31/12/2013
90
41
Service
06/03/1999
05/04/2014
30
48
Service
14/01/2013
13/01/2014
0
53
Service
01/05/2008
01/05/2014
90
64
Service
25/02/2010
24/02/2014
90
76
License
01/03/2012
28/02/2014
90
89
Service
31/03/2011
30/03/2014
90
93
Service
04/03/2013
03/03/2014
30
96
Service
11/09/1997
10/09/2014
180
99
Service
01/10/2012
31/10/2013
22
103
Service
11/04/2013
30/04/2014
90
123
Service
15/04/2011
14/04/2014
90
136
Service
01/04/2013
31/03/2014
15
138
Maintenance
01/04/2004
31/03/2014
90
150
Service
24/04/2010
23/04/2014
90
156
Subscription
07/05/2013
06/05/2014
180
167
Subscription
12/02/2013
01/01/2014
14
176
Service
01/05/2011
31/10/2013
90
180
Service
01/03/2012
28/02/2014
90
182
Maintenance
01/02/2013
31/01/2014
180
184
Service
28/05/2012
27/05/2014
60
198
Service
13/07/2012
31/10/2013
90
232
Service
26/11/2012
01/11/2013
30
243
Service
24/01/2013
23/01/2014
30
251
Service
04/03/2013
03/03/2014
30
252
Goods
01/04/2013
31/03/2014
90
100d
Service
09/05/2001
08/05/2014
60
181a
Service
20/03/2012
19/03/2014
90
181b
Service
27/03/2012
26/03/2014
45
9a
Service
22/04/2010
21/04/2013
30
9b
Service
01/03/2009
28/02/2014
30
Please take the necessary action within 30 calendar days to either renew or terminate this contract.
Please note it is your responsibility to get a new contract ( if required) signed by the Financial Controller and the General Manager.
No further payments will be processed to the supplier after the contract expiry date unless the relevant paperwork is received.
thanks Anu ..
PS: Attachment Removed.. (Deb)
i have one data file with one macro. now from this macro auto mail send to user when contract going to expire.
now i want if user is same and his more then one aacounts going to expire in this case mail should be like
Dear
The Below contract is due for notice of renewal/termination in 30 days.
Contract Number
Supplier Name
Description
Type
Contact Start Date
Contact End Date
Notice Period
1
Service
01/11/2012
31/03/2014
90
4
Service
01/10/2010
30/09/2013
120
5
Service
01/03/2011
28/02/2014
30
35
Service
01/01/2009
31/12/2013
90
41
Service
06/03/1999
05/04/2014
30
48
Service
14/01/2013
13/01/2014
0
53
Service
01/05/2008
01/05/2014
90
64
Service
25/02/2010
24/02/2014
90
76
License
01/03/2012
28/02/2014
90
89
Service
31/03/2011
30/03/2014
90
93
Service
04/03/2013
03/03/2014
30
96
Service
11/09/1997
10/09/2014
180
99
Service
01/10/2012
31/10/2013
22
103
Service
11/04/2013
30/04/2014
90
123
Service
15/04/2011
14/04/2014
90
136
Service
01/04/2013
31/03/2014
15
138
Maintenance
01/04/2004
31/03/2014
90
150
Service
24/04/2010
23/04/2014
90
156
Subscription
07/05/2013
06/05/2014
180
167
Subscription
12/02/2013
01/01/2014
14
176
Service
01/05/2011
31/10/2013
90
180
Service
01/03/2012
28/02/2014
90
182
Maintenance
01/02/2013
31/01/2014
180
184
Service
28/05/2012
27/05/2014
60
198
Service
13/07/2012
31/10/2013
90
232
Service
26/11/2012
01/11/2013
30
243
Service
24/01/2013
23/01/2014
30
251
Service
04/03/2013
03/03/2014
30
252
Goods
01/04/2013
31/03/2014
90
100d
Service
09/05/2001
08/05/2014
60
181a
Service
20/03/2012
19/03/2014
90
181b
Service
27/03/2012
26/03/2014
45
9a
Service
22/04/2010
21/04/2013
30
9b
Service
01/03/2009
28/02/2014
30
Please take the necessary action within 30 calendar days to either renew or terminate this contract.
Please note it is your responsibility to get a new contract ( if required) signed by the Financial Controller and the General Manager.
No further payments will be processed to the supplier after the contract expiry date unless the relevant paperwork is received.
thanks Anu ..
PS: Attachment Removed.. (Deb)
Last edited by a moderator: