I have a .csv file of all my clients, friend and family with their names and email addresses.
I want to have a system on my site where I can upload the .csv and then send the emails, so that each email that goes out sends a message to click to view their Christmas card, and when they click it it shows their card.
So to make up an example, it might be that
<[url removed, login to view]>
When clicked would take Sue and Paul to their card, which would say
Dear Sue and Paul,
Have a Happy Christmas and a Prosperous New Year - from Scott
With the Sue and Paul field being populated by the database.
The [url removed, login to view] template would be the same card for everyone, the only thing that changes of course is the name on the card.
My host is a Linux Host, I have full MySQL, PHP and FTP access.
I am open to ideas to achieve this objective to send the personalized ecards out or send visitors to a page that becomes personalized depending on who clicks the referrer link.
Hope that makes sense,
The template page I can design as an HTM and Flash static page. So you are quoting for the system, install, test and then for me to run it.