Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Good morning..

    I have the folliwing code inside my database so when I click on one of our staff name it starts up Outlook with the chaps name in the address bar:

    Private Sub Label247_Click()
    Application.FollowHyperlink "mailto:" & [Emailaddress]
    End Sub

    I am running two editions of Outlook on the system, and what I would like to do is use a particlar profile with the above code, would somebody know what I would add to do this?

    kind regards

    Steve Gulliver
    Southampton UK

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately, I don't believe it is possible to do what you describe. If Outlook is not currently running, that expression would start the default Outlook profile, and then create a new email message from that account. If Outlook is currently running, which it would be after the first use, then it would simply use the existing profile. I also looked at the possibility of using Automation, but it seems that approach would also use the default profile. Perhaps someone else will have an alternative approach....
    Wendell

  3. #3
    Lounger
    Join Date
    Oct 2008
    Location
    Southampton, Hampshire, United Kingdom
    Posts
    39
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Thank you very much indeed for replying.

    Steve Gulliver
    Southampton UK

Posting Permissions

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