Difficult Spec

[Guest_imported]

I have been given a requirement to develop a mailing list using asp.
That is not the problem as I have done that.
The problem comes in because they want me to display the of list of invited guests.
In other words, once an email is sent out to prospective guests, I need to create a link to allow guests to be able to see who else is invited.
Does anyone have an idea of how to incorporate the names of those on the mailing list and create a link like "Click here to see the full list of invitees"
thanks in advance

 

[vpekulas]

Whenever you send an email to the guest, mark his/her record in a database as 'invited guest. For example add
a field called 'INVITED' with a default value '0'. When you send the email make sure to set this value to '1' (as invited). Then create another file that would list records (people) only where 'INVITED' equals to '1'.
This way you can differentiate between the two.
If you need any help with it, I'll be happy to help you.

 

[Guest_imported]

Thank you vpekulas for your kindness.
Right now my table structure, which includes the new fields,
'INVITED' looks like this:
tablename = guests.
fields:
firstname,
lastname,
phone,
email,
city,
state,
zip,
country,
invited.

what I need now is to incorporate this into email program.
Any help from you would be greatly appreciated.