> With olMail
> > > > .To = ActiveSheet.Range("b" & I).Text
> > > > .Subject = "Congratulations on completion of " & Year(Now) -
> > > > Year(CDate(Range("D" & I).Value)) & " years of service"
>
ge("c" & I).Value)) Then
>
> > > > Set olMail = olApp.CreateItem(olMailItem)
> > > > With olMail
> > > > .To = ActiveSheet.Range("b" & I).Text
> > > > .Subject = "HappyBirthdayDear "
t; & I).Text
> > .Send
> > End With
>
> > Set olMail = Nothing
>
> > End If
>
> > Next I
> > Set olApp = Nothing
> > Application.ScreenUpdating = True
> > End Sub
>
> > Regards
> > Ashish koulhttp://akoul
play
> '.send
> End With
>
> Set olMail = Nothing
>
> End If
>
>
>> Regards
>> Ashish koul
>> http://akoul.blogspot.com/
>>
>>
>>
>> On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar <
>> kumar.bemlmum...@
>
>
> On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar <
> kumar.bemlmum...@gmail.com> wrote:
>
>> Could you please share how it is possible.
>>
>>
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> C.G
.
Regards,
C.G.Kumar
From: Chandra Gupt Kumar [mailto:kumar.bemlmum...@gmail.com]
Sent: Saturday, August 21, 2010 12:32 PM
To: 'ashish koul'
Cc: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ sending e mail based on data in column in
excel
Dear Koul,
Thanks fo
.
Regards,
C.G.Kumar
From: ashish koul [mailto:koul.ash...@gmail.com]
Sent: Saturday, August 21, 2010 11:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail based on data in column in
excel
check the attachment see if it helps you
Regards
Ashish koul
>
> C.G.Kumar
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Vasant
> *Sent:* Friday, August 20, 2010 1:43 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ sending
Could you please share how it is possible.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ sending e mail
Yes, it is possible to do
Regards
Vasant
On 8/20/10, Chandra Gupt Kumar wrote:
>
> Dear All,
>
>
>
> My requirements are as follows;
>
>
>
> 1. Based on date of birth (Col D), mail to be sent on particular day
> to respective office for good wishes.
>
> 2. Based on date of joining
10 matches
Mail list logo
