Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a way to determine if my users are using Lotus or Outlook via
VBA code. I'm sending out an email after all processing is done and I expected that all users were on Lotus, but now I've found out some are using outlook....BOOOOOOO!!! Thanks, Shelley |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi sbowman,
May be: Sub DefaultMailSoftware() Const Key As String = "HKLM\Software\Clients\Mail\" MsgBox CreateObject("WScript.Shell").regread(Key), 64 End Sub MP "sbowman" a écrit dans le message de news: ... I need a way to determine if my users are using Lotus or Outlook via VBA code. I'm sending out an email after all processing is done and I expected that all users were on Lotus, but now I've found out some are using outlook....BOOOOOOO!!! Thanks, Shelley |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() sbowman wrote: I need a way to determine if my users are using Lotus or Outlook via VBA code. I'm sending out an email after all processing is done and I expected that all users were on Lotus, but now I've found out some are using outlook....BOOOOOOO!!! Thanks, Shelley there is a key in the registry that indicates the default mail program. i forget which one, but i'm sure some googling will tell you. i don't know why it would matter tho as long as you can get the email to send from your machine, the end user should be able to open it with any mail client. i must be messing something. hope this (kind of) helps AR |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just an added thought.
That certainly tells you the default mail program, but mine is outlook and I often read some accounts with outlook express. So I guess it depends on what you want to achieve. -- Regards, Tom Ogilvy "Michel Pierron" wrote: Hi sbowman, May be: Sub DefaultMailSoftware() Const Key As String = "HKLM\Software\Clients\Mail\" MsgBox CreateObject("WScript.Shell").regread(Key), 64 End Sub MP "sbowman" a écrit dans le message de news: ... I need a way to determine if my users are using Lotus or Outlook via VBA code. I'm sending out an email after all processing is done and I expected that all users were on Lotus, but now I've found out some are using outlook....BOOOOOOO!!! Thanks, Shelley |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Thanks guys for all your help. How would I return the regkey value in a variable? All I'm trying to accomplish is send an email message, no attachments, pre determined body text, to a specified address. Should be easy right? Too bad I have a variable amount of users that use Lotus, and some that use Outlook!!! Thanks, Shelley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |