Email field in database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have worked out how to put a clickable email address in a database results
feild but would like to automatically add the same subject line to each
address - so when the user clicks on the address it will say something like
"Re your website details" Obviously I can ammend each one individually but
can we automate this?
 
In the DBRW filed displaying the email name (presuming it is not linked as a hyperlink)

Edit the results cell in the DBRW table from say

<%=FP_FieldVal(fp_rs,"email")%>
To

<a href="mailto:<%=FP_FieldVal(fp_rs,"email")%>?subject=Re your website details">
Email :<%=FP_FieldVal(fp_rs,"email")%></a>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have worked out how to put a clickable email address in a database results
| feild but would like to automatically add the same subject line to each
| address - so when the user clicks on the address it will say something like
| "Re your website details" Obviously I can ammend each one individually but
| can we automate this?
 
To add to Stefan's comments...

"RE your website details" is a subject line that has potential to get
trapped by spam filters.

Bob Lehmann
 
Stefan, modified the results field as you suggest but I get a warning saying
that any changes will be overwritten when the page is saved. I must be doinf
something wrong?
 
Edit the cell displaying the results (between the 2 yellow areas) in code view and Delete all the webbot code (Grayed out code) in
the cell

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Stefan, modified the results field as you suggest but I get a warning saying
| that any changes will be overwritten when the page is saved. I must be doinf
| something wrong?
|
| "Stefan B Rusynko" wrote:
|
| > In the DBRW filed displaying the email name (presuming it is not linked as a hyperlink)
| >
| > Edit the results cell in the DBRW table from say
| >
| > <%=FP_FieldVal(fp_rs,"email")%>
| > To
| >
| > <a href="mailto:<%=FP_FieldVal(fp_rs,"email")%>?subject=Re your website details">
| > Email :<%=FP_FieldVal(fp_rs,"email")%></a>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > |I have worked out how to put a clickable email address in a database results
| > | feild but would like to automatically add the same subject line to each
| > | address - so when the user clicks on the address it will say something like
| > | "Re your website details" Obviously I can ammend each one individually but
| > | can we automate this?
| >
| >
| >
 
add a field in your database called "subject"
then in the results wizard, edit the link and make the email line can be
mailto:<%=FP_FieldVal(fp_rs,"email")%>?subject=<%=FP_FieldVal(fp_rs,"subject")%>
 
Hi Bob, No, the wording was just an example... I guess it is the wording you
refer to rather than using automated input for the subject line?
 
Stefan, So I highlight the cell where the email results will show and go to
code. There is an awful lot of code greyed out - This is it: <!--webbot
bot="DatabaseResultColumn" startspan

s-columnnames="ID,Sector,Company,Contact,Website,Email,Telephone,Address,Position,Area,Salary,Per,Description,Remote_computer_name,Timestamp"
s-column="Email" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>Email<font
size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Email<font
size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="8328" endspan -->

apart from the code you suggest I replace (<%=FP_FieldVal(fp_rs,"Email")%>)
which is not greyed out.

I did what I thought you suggested but it did not work.!

What am I doing wrong??


Stefan B Rusynko said:
Edit the cell displaying the results (between the 2 yellow areas) in code view and Delete all the webbot code (Grayed out code) in
the cell

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Stefan, modified the results field as you suggest but I get a warning saying
| that any changes will be overwritten when the page is saved. I must be doinf
| something wrong?
|
| "Stefan B Rusynko" wrote:
|
| > In the DBRW filed displaying the email name (presuming it is not linked as a hyperlink)
| >
| > Edit the results cell in the DBRW table from say
| >
| > <%=FP_FieldVal(fp_rs,"email")%>
| > To
| >
| > <a href="mailto:<%=FP_FieldVal(fp_rs,"email")%>?subject=Re your website details">
| > Email :<%=FP_FieldVal(fp_rs,"email")%></a>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > |I have worked out how to put a clickable email address in a database results
| > | feild but would like to automatically add the same subject line to each
| > | address - so when the user clicks on the address it will say something like
| > | "Re your website details" Obviously I can ammend each one individually but
| > | can we automate this?
| >
| >
| >
Click to expand...
 
OK aaAndrew, I have made a new column called called subject in the database -
but not sure what you mean from there on ... If I call up the results wizard
there does not seem to be an option to edit a link. Can you talk me through
it again?

raymondo
 
Actually, found the solution: right click on email field on the results
field, select Hyperlink, Link to: Email Address, select Parameters, select
Insert Field Value, Highlight the fieldname containing the e-mail address
from the dropdown list and then add the text required to the Subject line.
Easy!
 
Back
Top