Email on Reports

J

Jen

I'll try to rephrase the question to better my help
chances. Field is hyperlink data type for email
addresses. By adding mailto: in front of each email it
acts as a hyperlink directly to open the SendTo window
with the email address filled in.

Problem is on reports I don't want to see the words
Mailto: If I try to use text functions to extract out
only the email portion, it places a # sign at the
beginning and end of the entry.

What's the easiest way to just get the email?
Why do some emails get a # sign placed at front & back
and others do not? Is there a way to edit the emails to
avoid?
 

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

Top