|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
June 10th 07, 06:20 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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
June 11th 07, 09:39 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
June 11th 07, 06:52 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
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 |
Linear Mode
