Re: [Jason] Website Membership and Postcode-based email
Hi Jason
I am intending to convert the list of reps from xls to SQL (MySQL) and upload them on the relevant server. The DB has all (as far as I am aware) the postcodes available in the UK, each of which is assigned to a particular team, and thence their email address, thus:
RSA Brick, GPO Postcode District, Postcode Description, Postcode Brick, RSA Brick Description, IMS PCOs, HMP Team, HPM Name, HPM Email Address
BT01, BT1, BELFAST 1, BT01, BELFAST 1*, Belfast Cg, KM01, HPM01, REP EMAIL
Obviously I've omitted the email for now. So I guess the relevant fields would be RSA Brick, GPO Postcode and HPM Email address. There are then 2840 more rows, hopefully covering all the postcodes. But on the offchance there was a wrong one, I would send these to a team email address to notify the team and thereby 'manually' notify the rep.
I hope this is what you need! Many thanks for your help.
Matt