adding a database field into email subject line

G

Guest

Almost finished my database thankyou! Just a couple more questions. I have a
email hyperlink in my database which includes a custom subject line. I would
like to include in the subject line a reference feild - so when a person
clicks the email link it looks something like this: Subject: Your
advertisement Reference No: ????? with the question marks being a feild in
the database <Ref> Is this possible, if so how?

Thanks again Anna.
 
S

Stefan B Rusynko

If Ref is your variable
In code view
<a href="mailto:[email protected]?Subject=Your advertisement Reference No: <%=Ref%>">Email me</a>

If Ref is your DB field name you need to make it a DB recordset ref as in: objRs("Ref")
--

_____________________________________________
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
_____________________________________________


| Almost finished my database thankyou! Just a couple more questions. I have a
| email hyperlink in my database which includes a custom subject line. I would
| like to include in the subject line a reference feild - so when a person
| clicks the email link it looks something like this: Subject: Your
| advertisement Reference No: ????? with the question marks being a feild in
| the database <Ref> Is this possible, if so how?
|
| Thanks again Anna.
 
G

Guest

Sorry, did not work. In my DRW page I have a email feild as such: <a
href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>?subject=Your Advertisement
Ref:"> the ref I need to insert is a database feild (called Ref). so what
would i have to insert?
 
T

Thomas A. Rowe

<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>?Subject=Your advertisement Reference No:
<%=FP_FieldLink(fp_rs,"Ref")%>">Email me</a>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

annaMac said:
Sorry, did not work. In my DRW page I have a email feild as such: <a
href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>?subject=Your Advertisement
Ref:"> the ref I need to insert is a database feild (called Ref). so what
would i have to insert?

Stefan B Rusynko said:
If Ref is your variable
In code view
<a href="mailto:[email protected]?Subject=Your advertisement Reference No: <%=Ref%>">Email me</a>

If Ref is your DB field name you need to make it a DB recordset ref as in: objRs("Ref")
--

_____________________________________________
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
_____________________________________________


| Almost finished my database thankyou! Just a couple more questions. I have a
| email hyperlink in my database which includes a custom subject line. I would
| like to include in the subject line a reference feild - so when a person
| clicks the email link it looks something like this: Subject: Your
| advertisement Reference No: ????? with the question marks being a feild in
| the database <Ref> Is this possible, if so how?
|
| Thanks again Anna.
 
G

Guest

Perfect! Thank you so much Thomas.

Thomas A. Rowe said:
<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>?Subject=Your advertisement Reference No:
<%=FP_FieldLink(fp_rs,"Ref")%>">Email me</a>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

annaMac said:
Sorry, did not work. In my DRW page I have a email feild as such: <a
href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>?subject=Your Advertisement
Ref:"> the ref I need to insert is a database feild (called Ref). so what
would i have to insert?

Stefan B Rusynko said:
If Ref is your variable
In code view
<a href="mailto:[email protected]?Subject=Your advertisement Reference No: <%=Ref%>">Email me</a>

If Ref is your DB field name you need to make it a DB recordset ref as in: objRs("Ref")
--

_____________________________________________
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
_____________________________________________


| Almost finished my database thankyou! Just a couple more questions. I have a
| email hyperlink in my database which includes a custom subject line. I would
| like to include in the subject line a reference feild - so when a person
| clicks the email link it looks something like this: Subject: Your
| advertisement Reference No: ????? with the question marks being a feild in
| the database <Ref> Is this possible, if so how?
|
| Thanks again Anna.
 

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