I want to send out my newsletter and have it update a record in a database 

when it is read. Kinda like a receipt.



This way I can delete users who do not read the newsletter.



I can't figure out how to do this in ASP?



Thanks

~R~

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C1BFCC.A4A895F0

Content-Type: text/plain;

	charset="iso-8859-1"



do users log into your site to read the newsletter?  otherwise I am not sure

you can do it unless you identify the user somehow.



 

 

 

David Debreceni

Senior Visual Basic/ASP Developer

xxx-xxx-xxxx  x 1086





-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: Wednesday, February 27, 2002 3:27 PM

To: ASP Web HowTo

Subject: [asp_web_howto] updating a record





I want to send out my newsletter and have it update a record in a database 

when it is read. Kinda like a receipt.



This way I can delete users who do not read the newsletter.



I can't figure out how to do this in ASP?



Thanks

~R~




$subst('Email.Unsub').

You can send them a link that will include username. like

http://mysite.com/article.asp?user=oleg



And when your page is called just check this username and update your

database with lets say current date.



Then you can run some script once a month and delete all users that didn't

read your letter for more then a week or month.



Oleg.



-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: February 27, 2002 3:27 PM

To: ASP Web HowTo

Subject: [asp_web_howto] updating a record





I want to send out my newsletter and have it update a record in a database

when it is read. Kinda like a receipt.



This way I can delete users who do not read the newsletter.



I can't figure out how to do this in ASP?



Thanks

~R~




$subst('Email.Unsub').

No, they do not log in.



Is there some way to set a variable equal to the current email address?

Then, perhaps I can use the onload function to submit a form maybe?



Thanks for your reply!



~R~

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C1BFCD.A02E3BF0

Content-Type: text/plain;

	charset="iso-8859-1"



You do pretty much what Oleg said to and use the email address or an id or

something to identify them in the database.  The only issue I would see with

that is if someone has it bookmarked or if someone types it in directly to

the address bar, you will not have the parameter and end up deleting someone

who may actually read the newsletter.  



 

 

 

David Debreceni

Senior Visual Basic/ASP Developer

xxx-xxx-xxxx  x 1086





-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: Wednesday, February 27, 2002 3:34 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





No, they do not log in.



Is there some way to set a variable equal to the current email address?

Then, perhaps I can use the onload function to submit a form maybe?



Thanks for your reply!



~R~




$subst('Email.Unsub').

Thank you Oleg for your response, but this still requires user 

interaction. I have found that they are more likely to read the newsletter 

if I send it to them than if I have them click a link to read it.



Thank you

~R~



> You can send them a link that will include username. like

> http://mysite.com/article.asp?user=oleg

> 

> And when your page is called just check this username and update your

> database with lets say current date.

> 

> Then you can run some script once a month and delete all users that 

didn't

> read your letter for more then a week or month.

> 

> Oleg.

 

so I understand that you going to send this article by e-mail, right ?

If so are you going to send it as Plain Text or HTML ?

In any case you can request a receipt for reading the e-mail so you could

get response

that your e-mail was read but users not always send you receipt

However you can let users know that they have to send this receipt in order

to continue

to receive this newsletters.

Then you'll just have to write some module that will accept this receipts

and process them.



If you going to send it as HTML e-mail you can open a windows as soon as

user opens your e-mail

and then submit some form back to server.



Oleg.



-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: February 27, 2002 3:46 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





Thank you Oleg for your response, but this still requires user

interaction. I have found that they are more likely to read the newsletter

if I send it to them than if I have them click a link to read it.



Thank you

~R~



> You can send them a link that will include username. like

> http://mysite.com/article.asp?user=oleg

>

> And when your page is called just check this username and update your

> database with lets say current date.

>

> Then you can run some script once a month and delete all users that

didn't

> read your letter for more then a week or month.

>

> Oleg.








$subst('Email.Unsub').

oleg,

that last suggestion is a very good one, the instruction for the opening of

a browser window can also be something like:"

< body onload window.open()>

where the function is described earlier in the code???

does this work totally the same?

txs

-----Original Message-----

From: Oleg Kapeljushnik [mailto:c-oleg.kapeljushnik@w...]

Sent: Wednesday, February 27, 2002 21:53

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





so I understand that you going to send this article by e-mail, right ?

If so are you going to send it as Plain Text or HTML ?

In any case you can request a receipt for reading the e-mail so you could

get response

that your e-mail was read but users not always send you receipt

However you can let users know that they have to send this receipt in order

to continue

to receive this newsletters.

Then you'll just have to write some module that will accept this receipts

and process them.



If you going to send it as HTML e-mail you can open a windows as soon as

user opens your e-mail

and then submit some form back to server.



Oleg.



-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: February 27, 2002 3:46 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





Thank you Oleg for your response, but this still requires user

interaction. I have found that they are more likely to read the newsletter

if I send it to them than if I have them click a link to read it.



Thank you

~R~



> You can send them a link that will include username. like

> http://mysite.com/article.asp?user=oleg

>

> And when your page is called just check this username and update your

> database with lets say current date.

>

> Then you can run some script once a month and delete all users that

didn't

> read your letter for more then a week or month.

>

> Oleg.








$subst('Email.Unsub').








$subst('Email.Unsub').

Yes,



I saw get few e-mails already that once I opened them some other window was

popped up.

It happened only when I get e-mail formatted as HTML page.

All you need to do, as you mentioned already, is create function that will

be executed once page is loaded.

For example:



<HTML>

<script language=JScript>

function init()

{

	window.open("readconfirm.asp");}

</script>



<BODY onload="init();">

</BODY>

</HTML>



The only thing you have to add to this is a parameter that will tell you

what user has open this page.

This probably will be created dynamically so you can do it like this :

	window.open("readconfirm.asp?User=<%=CurentUsername%>");



or you can also pass it as a parameter into init() function. Its your

personal preference.



Hope this what you wanted to know.



Oleg.



-----Original Message-----

From: Eric Van Camp [mailto:eric@a...]

Sent: February 28, 2002 2:46 AM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





oleg,

that last suggestion is a very good one, the instruction for the opening of

a browser window can also be something like:"

< body onload window.open()>

where the function is described earlier in the code???

does this work totally the same?

txs

-----Original Message-----

From: Oleg Kapeljushnik [mailto:c-oleg.kapeljushnik@w...]

Sent: Wednesday, February 27, 2002 21:53

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





so I understand that you going to send this article by e-mail, right ?

If so are you going to send it as Plain Text or HTML ?

In any case you can request a receipt for reading the e-mail so you could

get response

that your e-mail was read but users not always send you receipt

However you can let users know that they have to send this receipt in order

to continue

to receive this newsletters.

Then you'll just have to write some module that will accept this receipts

and process them.



If you going to send it as HTML e-mail you can open a windows as soon as

user opens your e-mail

and then submit some form back to server.



Oleg.



-----Original Message-----

From: Ron Feathers [mailto:ron@e...]

Sent: February 27, 2002 3:46 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: updating a record





Thank you Oleg for your response, but this still requires user

interaction. I have found that they are more likely to read the newsletter

if I send it to them than if I have them click a link to read it.



Thank you

~R~



> You can send them a link that will include username. like

> http://mysite.com/article.asp?user=oleg

>

> And when your page is called just check this username and update your

> database with lets say current date.

>

> Then you can run some script once a month and delete all users that

didn't

> read your letter for more then a week or month.

>

> Oleg.








$subst('Email.Unsub').








$subst('Email.Unsub').








$subst('Email.Unsub').