Hyperlink and Email

M

Memento

Hi Guys,

I'm trying to use the following expression to prepare my email addresses.
This expression should take the firstname and lastname, convert it all to
lowercase characters, append @somewhere.xx, and with the Left instruction
hide the mailto: of the string.

"Mailto:" has to be used, because otherwise Access assumes the HTTP protocol
instead of the Mailto: protocol. Programmatically creating emails if
cumbersome: if done wrong, nothing happens when you click on a
programmatically created email address.

But i'm guessing here this cannot be done as I want it to.

The txtEmail field is nowhere written yet at this point in code, in the
actual procedure there is first a check to see if the email exists, if it is
not, it's allowed to write the new email address in the underlying format to
the table.

What's happening with this code? I'm getting a "Illegal procedure call or
Illegal argument" error message... anyone sees a correct line in here??

txtEmail = (LCase("#mailto:" & (Left(txtSurName, InStr(1, txtSurName, "#") -
1) & "#") & "." & ReplaceWithDots(LCase(txtLastName) & "@somewhere.xx")))

Thanks in advance guys,

With regards,

Sven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically creating email, checking if exists 1
Creating a logonname automatically 5
Creating a logonname part 3 3
Code writes to subsequent record instead of current record 3
Synchronization problems while moving folders to new email 1
Keep original senders email address as hyperlink when forwarding 1
Concatenating & trim contents of 2 textboxes and write in another 5
mailto and unicode characters 0

Top