PC Review


Reply
Thread Tools Rate Thread

adding a database field into email subject line

 
 
=?Utf-8?B?YW5uYU1hYw==?=
Guest
Posts: n/a
 
      11th Nov 2005
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.
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      11th Nov 2005
If Ref is your variable
In code view
<a href="private.php?do=newpm&u=?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/FrontPa...3/Default.aspx
_____________________________________________


"annaMac" <(E-Mail Removed)> wrote in message news:9AB97AC5-038C-4F21-8CC9-(E-Mail Removed)...
| 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.


 
Reply With Quote
 
=?Utf-8?B?YW5uYU1hYw==?=
Guest
Posts: n/a
 
      11th Nov 2005
Great! I will try it.

"Stefan B Rusynko" wrote:

> If Ref is your variable
> In code view
> <a href="private.php?do=newpm&u=?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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "annaMac" <(E-Mail Removed)> wrote in message news:9AB97AC5-038C-4F21-8CC9-(E-Mail Removed)...
> | 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.
>
>
>

 
Reply With Quote
 
=?Utf-8?B?YW5uYU1hYw==?=
Guest
Posts: n/a
 
      11th Nov 2005
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" wrote:

> If Ref is your variable
> In code view
> <a href="private.php?do=newpm&u=?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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "annaMac" <(E-Mail Removed)> wrote in message news:9AB97AC5-038C-4F21-8CC9-(E-Mail Removed)...
> | 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.
>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      11th Nov 2005
<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" <(E-Mail Removed)> wrote in message
news:C62C8FE6-F0EA-40FD-A70B-(E-Mail Removed)...
> 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" wrote:
>
>> If Ref is your variable
>> In code view
>> <a href="private.php?do=newpm&u=?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/FrontPa...3/Default.aspx
>> _____________________________________________
>>
>>
>> "annaMac" <(E-Mail Removed)> wrote in message
>> news:9AB97AC5-038C-4F21-8CC9-(E-Mail Removed)...
>> | 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.
>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?YW5uYU1hYw==?=
Guest
Posts: n/a
 
      11th Nov 2005
Perfect! Thank you so much Thomas.

"Thomas A. Rowe" wrote:

> <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" <(E-Mail Removed)> wrote in message
> news:C62C8FE6-F0EA-40FD-A70B-(E-Mail Removed)...
> > 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" wrote:
> >
> >> If Ref is your variable
> >> In code view
> >> <a href="private.php?do=newpm&u=?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/FrontPa...3/Default.aspx
> >> _____________________________________________
> >>
> >>
> >> "annaMac" <(E-Mail Removed)> wrote in message
> >> news:9AB97AC5-038C-4F21-8CC9-(E-Mail Removed)...
> >> | 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.
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Defining Subject Line in an Email from a field in the report Mark Andrews Microsoft Access Reports 0 24th Mar 2009 08:15 PM
adding attachments in field below subject not as an icon in email =?Utf-8?B?SkNoZWxwbWU=?= Microsoft Outlook Discussion 1 14th Sep 2006 06:30 PM
Can I use a merge field in the subject line of an email template =?Utf-8?B?U2hlbGxleVFC?= Microsoft Outlook Form Programming 1 29th Mar 2005 09:44 PM
not subject, but email text, export to fields, line by line =?Utf-8?B?Ym9va2JhbmU=?= Microsoft Outlook Discussion 0 24th Nov 2004 02:42 AM
Adding code to ThisOutlookSession Made Incoming Subject Line to Have Now() as Subject Mark Microsoft Outlook VBA Programming 1 9th Feb 2004 05:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:52 AM.