I am using FP 2003 with XP SP and IIS 5.1 to develop my site prepatory to loading it onto the server. I have a results page which is a list of names and email addresses. I would like the user to be able to click on the email address, and then have their relative email client invoked, eg: Outlook Express in my case.
thanks
Ursa
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I do wish to appear too dense, but I do not follow. At the moment I am playing around with a handful of names, but potentially there is going to be in exces of 500. I do not want to type these in individually. I thought FP could be sent up to call OE once the user clicked on an email address?
tks
Ursa
As your editing your web page in FrontPage, simply type in
John Doe johndoe@yourcompany.com
Where John Doe is the user's name and johndoe@yourcompany.com is his email address.
As brundo said, just make sure to press the space bar after his email address, and frontpage will make it into an email link.
another way of making any text/image a link is to:
hightlight the text or picture
press Ctrl K (or right click the mouse and left click hyperlink)
in the link field, type in mailto:johndoe@yourcompany
where johndoe@yourcompany.com is the email address you want to link to.
Sorry, still not with you. This is all happening in a results page where 'email address' is one of the fields. I am trying to have FP invoke the email client of choice when they click on that field.
If I click on the hyperlink properties option, and then insert field, email address, this is whats is inserted
"mailto:'%3c%25=FP_FieldLi
which suggests that FP is trying to get the relevant email address. When the file is run in a browser,
it gets turned into a URL, http://graham/stumps009@ya
Am I heading in the right direction, or being unintentionally thic
Ursa
Let's try from the beginning:
> I am trying to have FP invoke the email client of choice
> when they click on that field.
FP will not do this. FP will only insert a hyperlink at this place and color it in the appropriate color.
When your page is shown in a browser, browser will invoke the e-mail client program (if one is installed on the computer on which the pages are shown).
> When the file is run in a browser, it gets turned into a URL,
> http://graham/stumps009@ya
I see where is your problem: FP cannot decide if graham/stumps009@yahoo.com
Me too :-(( My question is: are you sure it is the e-mail address? Maybe it is graham.stumps009@yahoo.com
If you are sure, you have to fool FP :-)) :
Copy all your addresses (500 od less), and paste them as text in your document (after pasting, look at the button which arises right, near the pasted text; choose down arrow and then "Keep text only").
After that type your blank, enter or what you want after each of addresses.
I see other solutions, too, but they need some experience in pure HTML editing. I hope this one will work...
Time for me to take a deep breath. The document is the results_page.asp from the Database Interface Wizard and only contains the five fields, so when it is called by the browser the text is blocked according the the field layout, email address included. As you can see, it is not a textual document at this stage.
ursa
UsraMajor,
sorry, I was three days on a very slow Internet connection... Unexpected :-((
Today I had a problem similar to yours, and solved it. I had a field in an Access 2003 database of type hyperlink - Access adds a http:// in front of it (and the link doesn't work). In that field there should stay e-mail addresses, like in your case.
Then I changed the type into text, and Access wrote e.g. snoopy@yahoo.aq#http://sno
Is your field with e-mail address? What happens when you change your field type into text? For a handful of addresses you can change it by editing, later you will get the real addresses in your field.
Ok, the database is correct, the field content too.
When you look at the hyperlink properties, you see:
"mailto:'%3c%25=FP_FieldLi
What do you see when you switch to the Code View of your page (e.g. via tab at the bottom of the window)?
<a href="mailto:<%=FP_FieldLi
The first link,
<a href="Email%20Address'<%=F
</a>
doesn't show to a e-mail address and is empty. So, it can be deleted.
I would leave only:
<a href="mailto:<%=FP_FieldLi
There is something interesting _after_ this <a href...> tag - probably a FP_FieldVal with a text which should appear as a link, and a closing </a> tag.
How it looks like now?
Maroon is sign for code - e.g. =FP_FieldLink(fp_rs,"Email
No matter what you experiment, you should make a copy of your page before starting.
You should have something like:
Click for e-mail: <a href="mailto:<%=FP_FieldLi
where Name is the field with names of people in your table. <%...%> parts should be maroon, mailto and quotes blue, href red, a purple....
If you want, you can copy your whole maroon part of the code.
Hereis the code which surreounds the mailto:
<!--#include file="_fpclass/fpdbrgn1.in
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="64795" --><tr>
<td><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn"
<td><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn"
<td><font face="Verdana" size="2">
<!--webbot bot="DatabaseResultColumn"
<td><font face="Verdana" size="2">
</font>
<a href="Email%20Address'<%=F
</a><a href="mailto:'<%=FP_FieldL
<!--webbot bot="DatabaseResultColumn"
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
You have really chaos around your e-mail field!
I would delete all the code:
<td><font face="Verdana" size="2">
</font>
<a href="Email%20Address'<%=F
</a><a href="mailto:'<%=FP_FieldL
<!--webbot bot="DatabaseResultColumn"
...and would type:
<a href="mailto:<%=FP_FieldLi
instead of it. It is shorter, and has no gray text, because the wizard (webbot) will not work on it. But, once it works, wizard is not necessary anymore...
The other solution (after deleting) is to try once more with the wizard.
I hope it works now :-))
First, sorry, if you've deleted what I suggested you, you should insert:
<a href="mailto:<%=FP_FieldLi
:-((
Let's try with just displaying the function results instead of link:
<td>
...<%=FP_FieldLink(fp_rs,"
</td>
What does it display?
Did you try with the wizard after deleting the block? E.g. like in the http://www.spiderwebwoman.
> It ignores...
... which program, how the page is accesses?
Explanation of the question: <%=FP_FieldLink(fp_rs,"Ema
When looking at the page in the web browser, accessing it through localhost (or your server, graham), all the functions in <%=...%> should be run, and the results have to be shown.
Gray text, <!-- webbot ... --> is only for FrontPage, to enable usage of wizards. It has nothing to do with server and can be deleted.
* * *
When it doesn't work, you can still:
- delete the column with e-mail address (otherwise you can get empty links or
something like this, like in the previous example)
- make a new column with the e-mail address (after instructions from
spiderwebwoman I wrote in the last mail).
Now I have no access to Microsoft servers :-(( Even at my computer I have to have another one, so, I cannot test your example :-((
> It ignores the DBRW position of the email field and puts it in the left hand column.
When I come back to your question, I see you didn't write anything about the link: is the position the only remaining problem?
This problem is about opening and closing tr and td tags, and can be solved easily (you can send the code once again).
Is this how it should look: because if it is, then I have deleted too much as it does not run.
Rather than exasperate your time and patiesnce any further, I think this may be a task that it not easily achievable in Frontpage and I would like to award you the points and move on.
What do you think.
tks
Ursa
> Rather than exasperate your time and patiesnce any further, I think this may be a task that it not easily achievable in Frontpage
One of problems using editors like FrontPage (WYSIWYG) without fully understanding the background (HTML, ASP etc.) is that while experimenting often remain traces... So, you have 3 links to e-mail, and only one is correct. But, to make it work, you have to delete the rest :-((
Did you try completely delete the column and try once again (as I wrote in the second part of the post from 18.7.)?
>I would like to award you the points and move on.
I would not recommend this, deleting the question would be a regular option according to http://www.experts-exchang
The only idea I have is to suggest you to upload your file to the www.ee-stuff.com... and let me see what happened.
It would be good if it would be a file with "clear" attempt - i.e. after deleting the whole column with e-mail and inserting a new field.
Business Accounts
Answer for Membership
by: brundoPosted on 2007-07-10 at 23:03:29ID: 19460150
An e-mail address, when you type it in and press space after it, should be converted into e-mail link. This is what you want :-))
If you already have a list of addresses, you can:
- type a space after each one (let the FP to make a link), and then delete the space
** or **
- right click at the address > Hyperlink > choose "e-mail address" > type the address in