Results 1 to 3 of 3

Thread: Add Outlook Email account using VBA from Excel

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 2004
    Posts
    48

    Add Outlook Email account using VBA from Excel

    Im assuming it can be done, because 30 min's googling came up with nothing.

    What i need to do is make it easier for staff at the school i work at to set up outlook to access their school email accounts...... they dont want to be adding pop and smtp details, and i dont want to set up 200+ machines

    So far ive got a user form in Excel (its in excel because it looks 'freindly' to the staff) which collects the username (email address) and password in two txt boxes and thats basically all i need, the rest of the details (pop, smtp etc) all the same!

    How would i go about adding the account? I dont want a complete step by step guide, just a gentle prod in the right direction a-la RobDog

    Cheers in advance

    Chris
    Last edited by c03cg; Mar 10th, 2006 at 10:08 AM.

  2. #2

    Thread Starter
    Member
    Join Date
    Nov 2004
    Posts
    48

    Re: Add Outlook Email account using VBA from Excel

    As there's been no respone posted, does that mean it can't be done?

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Add Outlook Email account using VBA from Excel

    I'm here but just for a bit.

    There is a utility or part of Exchange server maybe that is called something like profile manager which helps to deploy outlook profiles to other systems like when used in a network environment. There are a few posts on it here on the forums. Sorry I cant remember more right now but I need to get soem sleep soon.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width