A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Get SMTP Server from Outlook



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 10th 07, 06:20 PM posted to microsoft.public.outlook.program_vba
Greg Lovern
external usenet poster
 
Posts: 3
Default Get SMTP Server from Outlook

I have an Excel VBA macro that sends mail using CDO. Works fine, but
users have to enter their SMTP Server in a designated cell.

Most of the users are using Outlook. Can I get the SMTP Server name
from Outlook by automating Outlook?


Thanks,

Greg

Ads
  #2  
Old June 11th 07, 09:39 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Get SMTP Server from Outlook



It's in the registry. For Outlook 2003 e.g. it's:

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows
Messaging Subsystem\Profiles\[Profile]\9375CFF0413111d3B88A00104B2A6676\

In the subkeys you have to search for the specific account name and read the
SMTP Server property.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sun, 10 Jun 2007 09:20:39 -0700 schrieb Greg Lovern:

I have an Excel VBA macro that sends mail using CDO. Works fine, but
users have to enter their SMTP Server in a designated cell.

Most of the users are using Outlook. Can I get the SMTP Server name
from Outlook by automating Outlook?


Thanks,

Greg

  #3  
Old June 11th 07, 06:52 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Get SMTP Server from Outlook

plug
Or you can do that using Redemption: RDOPOP3Account.SMTP_Server -
http://www.dimastr.com/redemption/rd...RDOPOP3Account
/plug

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Michael Bauer [MVP - Outlook]" wrote in message
.. .


It's in the registry. For Outlook 2003 e.g. it's:

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows
Messaging Subsystem\Profiles\[Profile]\9375CFF0413111d3B88A00104B2A6676\

In the subkeys you have to search for the specific account name and read
the
SMTP Server property.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:

http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Sun, 10 Jun 2007 09:20:39 -0700 schrieb Greg Lovern:

I have an Excel VBA macro that sends mail using CDO. Works fine, but
users have to enter their SMTP Server in a designated cell.

Most of the users are using Outlook. Can I get the SMTP Server name
from Outlook by automating Outlook?


Thanks,

Greg



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SMTP server in Outlook Bangali Outlook - General Queries 2 April 19th 07 03:39 PM
Bizarre - Outlook not using the right SMTP server Logan Noyes Outlook - General Queries 8 January 19th 07 06:45 AM
Can't connect to smtp server, Outlook & Express TV Outlook - Installation 3 August 16th 06 11:15 PM
SMTP Server Outgoing server settings Jhoy Outlook - Installation 0 August 3rd 06 04:22 PM
Outlook 2003 SMTP server not responding Dovka M Outlook - Installation 0 January 20th 06 07:11 PM


All times are GMT +1. The time now is 10:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.