Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

2012-01-10 Thread PrIyAnKa 
Subject and body will be simple

e.g. Sub : Data for the month Jan-12

and Email Body : Dear Sir/Mam

Kindly find the attached file

On Tue, Jan 10, 2012 at 4:08 PM, Anish Shrivastava wrote:

> Hi Priyanka,
>
> I have a written a macro which does similar task, but I just wanted to
> check with you about "Subject" and "Mail Body" of the email.
>
> What would be the Subject and what should be written in the mail?? If you
> can give me these 2, I will modify the macro and send it to you.
>
> Regards,
> Anish
>
> On Tue, Jan 10, 2012 at 3:11 PM, PrIyAnKa  wrote:
>
>> Dear Team
>>
>> In an excel sheet  have data in A column "Employee Name ", in B Column "
>> email id of concern Employee"
>>
>> I h ave a folder of PDF files, PDF file name are same as Employee Name
>> and there is a PDF for all employee
>>
>> I want to send concern Employee his own named PDF from that folder to the
>> email ID mentioned in column B in excel
>>
>> Kindly help for such macro ,
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

2012-01-10 Thread PrIyAnKa 
Dear Noorain

I have already tried this

Kindly suggest if there is some other way

On Tue, Jan 10, 2012 at 5:14 PM, NOORAIN ANSARI wrote:

> Hi Priyanka,
>
> Check below link, hope it will help to you.
> http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Tue, Jan 10, 2012 at 3:11 PM, PrIyAnKa  wrote:
>
>> Dear Team
>>
>> In an excel sheet  have data in A column "Employee Name ", in B Column "
>> email id of concern Employee"
>>
>> I h ave a folder of PDF files, PDF file name are same as Employee Name
>> and there is a PDF for all employee
>>
>> I want to send concern Employee his own named PDF from that folder to the
>> email ID mentioned in column B in excel
>>
>> Kindly help for such macro ,
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

2012-01-10 Thread NOORAIN ANSARI 
Hi Priyanka,

Check below link, hope it will help to you.
http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Tue, Jan 10, 2012 at 3:11 PM, PrIyAnKa  wrote:

> Dear Team
>
> In an excel sheet  have data in A column "Employee Name ", in B Column "
> email id of concern Employee"
>
> I h ave a folder of PDF files, PDF file name are same as Employee Name and
> there is a PDF for all employee
>
> I want to send concern Employee his own named PDF from that folder to the
> email ID mentioned in column B in excel
>
> Kindly help for such macro ,
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

2012-01-10 Thread Anish Shrivastava 
Hi Priyanka,

I have a written a macro which does similar task, but I just wanted to
check with you about "Subject" and "Mail Body" of the email.

What would be the Subject and what should be written in the mail?? If you
can give me these 2, I will modify the macro and send it to you.

Regards,
Anish

On Tue, Jan 10, 2012 at 3:11 PM, PrIyAnKa  wrote:

> Dear Team
>
> In an excel sheet  have data in A column "Employee Name ", in B Column "
> email id of concern Employee"
>
> I h ave a folder of PDF files, PDF file name are same as Employee Name and
> there is a PDF for all employee
>
> I want to send concern Employee his own named PDF from that folder to the
> email ID mentioned in column B in excel
>
> Kindly help for such macro ,
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excel macro to send mail with other than excel attachment

2012-01-10 Thread PrIyAnKa 
Dear Team

In an excel sheet  have data in A column "Employee Name ", in B Column "
email id of concern Employee"

I h ave a folder of PDF files, PDF file name are same as Employee Name and
there is a PDF for all employee

I want to send concern Employee his own named PDF from that folder to the
email ID mentioned in column B in excel

Kindly help for such macro ,

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com