Opening email and websites

[MarkStanley]

Hi all, I am a new member and haven't been working with Access much for the past 10 years so a bit rusty. I am in the process of building a CRM system (single user) and need a bit of help with the following:

a) I have a button in a Contact Form to create an email. The email address field is set up as a text field, not hyperlink. When I click the button it opens a web client to my personal email account in Offices 365. I would like to create the email from my Outlook installed client, but have three email accounts so need to direct it to a specific email account. Does anyone know what VBD code is required in the button to achieve this.

b) I have a button on my Contact Form to open the contacts LinkedIn page. The LinkedIn field is set up as a text field. Does anyone know what VBD code is required in the button to achieve this.

c) I also have a button on my Company Form to open the companies website. The field is set up as a text field. Does anyone know what VBD code is required in the button to achieve this.

Thanks in advance for your help and advice.
Regards
Mark

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

FYI, I have moved your thread to a more appropriate forum.

 

[MarkStanley]

Thanks Jon, nice to meet you. I will post an introduction a bit later.

 

[Gasman]

Use SendUsiningAccount.

  .SendUsingAccount = objOutlook.Session.Accounts.Item(intAccount)

where intAccount is the numeric number for that account in the list.

If you need to identify which account, they are numerically ordered by your account list, but I also have code to identify that particular account if needed, if you change the order, or remove some.

 

[Pat Hartman]

If you want to open any file type that is defined to windows, you can use the FollowHyperlink method. It will open websites, email, Excel, Word, etc.