Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Please add me to the people wishing to send mail using g mail or yahoo What am I looking for 1. Log in = I am ready to log in thru VBA or thru browser 2. Send mail = I will cut and paste recipients , first name, subject, body in the places dedicated / decided by you on the XL sheet. Click a button and mail should be sent out of yahoo mail or g mail 3. These are standard mail , news letter sort of stuff thanks in advance Best regards On Friday, January 4, 2013 10:59:01 AM UTC+4, ankur aggarwal wrote: Thanks a lot Mohan, Its working fine and its allowing person to sign in via yahoo and gmail. Can we send an email to someone by giving recipient ID through a macro ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. -- *From:* अनिल नारायण गवली gawlia...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript:; mohan.p...@gmail.comjavascript: *Sent:* Friday, 4 January 2013 10:52 AM *Subject:* Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Dear Mohan, Pls find attached its give u some egto work.. Regards, Gawli Anil On Fri, Jan 4, 2013 at 10:48 AM, amar takale amart...@gmail.comjavascript: wrote: Hi Mohan, A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query Appreciate the help Let us know in case of any further assistance. Thanks Regards Amar On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL ankur9_a...@yahoo.co.injavascript: wrote: Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur -- *From:* mohan.p...@gmail.com javascript: mohan.p...@gmail.comjavascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Friday, 4 January 2013 12:13 AM *Subject:* Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel -- *From: * ANKUR AGGARWAL ankur9_a...@yahoo.co.in javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Fri, 4 Jan 2013 02:40:10 +0800 (SGT) *To: *excel-...@googlegroups.com javascript: excel-macros@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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.p...@gmail.com javascript: mohan.p...@gmail.comjavascript: *To:* excel-...@googlegroups.com javascript: *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_a...@yahoo.co.in javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Fri, 4 Jan 2013 02:07:47 +0800 (SGT) *To: *Lalit Mohan Pandeymohan.p...@gmail.com javascript:; excel-...@googlegroups.com javascript:excel-macros@googlegroups.comjavascript: *ReplyTo: * excel-...@googlegroups.com javascript: *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.p...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Cc:* ANKUR AGGARWAL ankur9_a...@yahoo.co.in javascript: *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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
hi dear, the code provide by lalit mohan doing the same please check that, i hope it is 90 percent full felling ur requirement it just need a small modification. regards prince On Saturday, January 5, 2013 9:09:21 PM UTC+5:30, .. wrote: Please add me to the people wishing to send mail using g mail or yahoo What am I looking for 1. Log in = I am ready to log in thru VBA or thru browser 2. Send mail = I will cut and paste recipients , first name, subject, body in the places dedicated / decided by you on the XL sheet. Click a button and mail should be sent out of yahoo mail or g mail 3. These are standard mail , news letter sort of stuff thanks in advance Best regards On Friday, January 4, 2013 10:59:01 AM UTC+4, ankur aggarwal wrote: Thanks a lot Mohan, Its working fine and its allowing person to sign in via yahoo and gmail. Can we send an email to someone by giving recipient ID through a macro ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. -- *From:* अनिल नारायण गवली gawlia...@gmail.com *To:* excel-...@googlegroups.com; mohan.p...@gmail.com *Sent:* Friday, 4 January 2013 10:52 AM *Subject:* Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Dear Mohan, Pls find attached its give u some egto work.. Regards, Gawli Anil On Fri, Jan 4, 2013 at 10:48 AM, amar takale amart...@gmail.com wrote: Hi Mohan, A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query Appreciate the help Let us know in case of any further assistance. Thanks Regards Amar On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL ankur9_a...@yahoo.co.inwrote: Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur -- *From:* mohan.p...@gmail.com mohan.p...@gmail.com *To:* excel-...@googlegroups.com *Sent:* Friday, 4 January 2013 12:13 AM *Subject:* Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel -- *From: * ANKUR AGGARWAL ankur9_a...@yahoo.co.in *Sender: * excel-...@googlegroups.com *Date: *Fri, 4 Jan 2013 02:40:10 +0800 (SGT) *To: *excel-...@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-...@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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.p...@gmail.com mohan.p...@gmail.com *To:* excel-...@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_a...@yahoo.co.in *Sender: * excel-...@googlegroups.com *Date: *Fri, 4 Jan 2013 02:07:47 +0800 (SGT) *To: *Lalit Mohan Pandeymohan.p...@gmail.com; excel-...@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-...@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.p...@gmail.com *To:* excel-...@googlegroups.com *Cc:* ANKUR AGGARWAL ankur9_a...@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
$$Excel-Macros$$ 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.
$$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.
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 -Original Message- From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:07:47 To: Lalit Mohan Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: 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.
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel -Original Message- From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:40:10 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur From: mohan.pande...@gmail.com mohan.pande...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:13 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:40:10 +0800 (SGT) To: excel-macros@googlegroups.comexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Hi Mohan, A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query Appreciate the help Let us know in case of any further assistance. Thanks Regards Amar On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur -- *From:* mohan.pande...@gmail.com mohan.pande...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 4 January 2013 12:13 AM *Subject:* Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel -- *From: * ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in *Sender: * excel-macros@googlegroups.com *Date: *Fri, 4 Jan 2013 02:40:10 +0800 (SGT) *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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
Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba
Thanks a lot Mohan, Its working fine and its allowing person to sign in via yahoo and gmail. Can we send an email to someone by giving recipient ID through a macro ? Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com; mohan.pande...@gmail.com Sent: Friday, 4 January 2013 10:52 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba Dear Mohan, Pls find attached its give u some egto work.. Regards, Gawli Anil On Fri, Jan 4, 2013 at 10:48 AM, amar takale amartak...@gmail.com wrote: Hi Mohan, A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share market are open then show current price after closing market it show closing price.When I wish to add any stock in excel it is also updated price.It is all update automatically,I think it is possible from Data-Import External Data Query Appreciate the help Let us know in case of any further assistance. Thanks Regards Amar On Fri, Jan 4, 2013 at 9:28 AM, ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in wrote: Thanks for providing the link Mohan. But unfortunately its giving me an error, file is corrupted and cannot be saved. Warm Regards Ankur From: mohan.pande...@gmail.com mohan.pande...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 4 January 2013 12:13 AM Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba The link which I have sent you is my blog and I have done this for google login. At that time it was working. Sent from BlackBerry® on Airtel From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Fri, 4 Jan 2013 02:40:10 +0800 (SGT) To: excel-macros@googlegroups.comexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba 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 Pandeymohan.pande...@gmail.com; excel-macros@googlegroups.comexcel-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