I require an invitation managment system that integrates club member information in Excel that includes email address, contact names and status fields with Outlook to create invitations to forthcoming events and integrate the responses back into Excel.
The inivtaiton must be customisable to allow for:-
Start and end time
Location if poss linked to online mapping such as Google maps
Ability to invite others
Poll of upto 10 items from either lists or write ins
Once set up the invitations will be sent via Outlook
System needs to track responses and record them back to the excel database including polled answers
A summary of attendees and rejections as well as non respondents must be calculated with the ability to remind non responders to do so.