Hi Group, I want to seek help regarding CDO Object
I have designed a sheet, which contains User Form, which allows a user to send an email. It has been programmed to send email through Gmail server. I am facing the following problem: 1) The variable storing the user name and passwrod supplied by the user, do not keep value stored once the focus shifts back to the module sending the email message. As result the CDO Object is not able to supply the correct credentials to the server. If i directly supply the username and password in the code, the code will work perfectly fine. 2) Is there a way to keep values stored in a variable throughout the time sheet is opened. I.e. the user should be asked for the credentials only once the sheet is opened. Thanks Harpreet Gujral -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Group.xls
Description: MS-Excel spreadsheet
