Using a particular Profile in Outlook via Access

Topic

New Reply

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

Reply | Quote

Replies

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….

Reply | Quote

Thank you very much indeed for replying.

Steve Gulliver
Southampton UK

Reply | Quote