Thanks, so you meant that you have logged in to the account but hasn't sent any email.
I have tried doing that, but after entering the details into my yahoo email id, its not allowing me to press enter, due to yahoo security. Can you shared your method ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. ________________________________ From: "mohan.pande...@gmail.com" <mohan.pande...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:06 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Yes I already did it. Need some time if you really want it but I have just log in the account not sure about sending email using vba. Sent from BlackBerry® on Airtel ________________________________ From: ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:07:47 +0800 (SGT) To: Lalit Mohan Pandey<mohan.pande...@gmail.com>; excel-macros@googlegroups.com<excel-macros@googlegroups.com> ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Hi Lalit, Thanks for the reply. Below link is not working and the file they have provided is not functioning. Even I have googled a lot, and it seems due to security concerns, gmail or yahoo servers are not allowing to access there web sites using a macro. Please let me know if you have tried the same at ur end ? Regards Ankur From: Lalit Mohan Pandey <mohan.pande...@gmail.com> To: excel-macros@googlegroups.com Cc: ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> Sent: Thursday, 3 January 2013 7:31 PM Subject: Re: Login to gmail/yahoo and send email using excel vba Hi Ankur, You can find an example to login in gmail account using vba at below mentioned link:- http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/ let us know for further assistance. Regards, Lalit Mohan On Thursday, 3 January 2013 19:11:36 UTC+5:30, ankur aggarwal wrote: Hi Team, > > >I wanted to run an excel macro which can automate yahoo/gmail process using >excel vba. Upon clicking of the button, it will send an email from a web >browser ( IE ) using yahoo/gmail to a given email id. > > >Can anybody please help in doing that ? I have written a macro which actually >opens IE and g mail web site, then I have created the HTML object and its >going to gmail website. But I am unable to proceed further (attach file and >send it to recipient ). > >Thanks in Advance ! > > >Warm Regards -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.