I am having an issue with an email field set as a hyperlink in the properties
If I click on the field, I can email directly from the field,but my Cmd button to email the contact in the top of the form, pastes two email addresses. when I looked in the table, there is a long string like the following:
...com# (example address)
Needless to say outlook won't email this address.
I have the email field set to hyperlink, so that I can click on the field to email, but would also like to email from link on form as well.
Is there a way to fix the code to work, or am I stuck with one option to email, either from the cmd button (and cleaning up the hyperlink stuff in the table) or the clicking on the field.
Below is a screen shot of macro