I need an Access Database to keep a list of people that we send out emails too. And I need this database to send emails through our own email server (Perhaps a menu that allows the details to be entered)
We have multiple mailing lists and would like the database to allow customers to be on multiple lists. Some of these emails send out a table of pricing that gets a margin added depending on customer and so the emails sent out would need to be margined for each individual customer. I would like the database to remain unlocked so things can be amended/added etc in future if required.
I would like the following tables:
Details (see below for fields)
Customer Company (only needs Company Name field)
Position (Only needs Position field)
Dealer (Only needs Dealer field)
Team (Only needs Dealer field)
Mailing Lists (see below for fields)
Rates (see below for fields)
I would the Details table to have the following fields and a form/forms if needed based on this that can enter/edit/search records:
Customer Name
Customer Company (Can be selected from drop down list of previous customers from Customer Company Table or new customer can be typed that updates the table)
Position (Can be selected from drop down list of previous Positions in the Position table or new position can be typed thats updates the table)
Email address
Dealer (Can only be selected from a drop down list based on Dealer table, this drop down list can only be amended by going into a separate menu and editing the dealer table)
Team (Can only be selected from a drop down list based on Team table, this drop down list can only be amended by going into a separate menu and editing the team table)
Customer (Yes/No)
Staff (Yes/No)
Mailing Lists On (Selected from combo Box that links to Mailing List table, What Mailing lists are in the combo box can only be amended by going to separate menu, customer can be added to multiple lists, can remove customer from lists after added)
Remove from all mailing lists button
Date removed from List (When above button clicked)
Interests (Big text box that allows details of customers interests to be kept)
Comments (Big text box that allows comments to be kept)
I would the Mailing List table to have the following fields and a form/forms if needed based on this that can enter/edit/search records:
Mailing List Name
Mailing List email subject
Rate based list (Yes/No – if yes then below to be filled out)
GBP Margin Instant Access (Number in format 0.00)
GBP Margin Overnight (Number in format 0.00)
GBP Margin 1 week (Number in format 0.00)
GBP Margin 2 weeks (Number in format 0.00)
GBP Margin 3 weeks (Number in format 0.00)
GBP Margin 1 month (Number in format 0.00)
GBP Margin 2 months (Number in format 0.00)
GBP Margin 3 months (Number in format 0.00)
GBP Margin 6 months (Number in format 0.00)
GBP Margin 9 months (Number in format 0.00)
GBP Margin 12 months (Number in format 0.00)
EUR Margin Instant Access (Number in format 0.00)
EUR Margin Overnight (Number in format 0.00)
EUR Margin 1 week (Number in format 0.00)
EUR Margin 2 weeks (Number in format 0.00)
EUR Margin 3 weeks (Number in format 0.00)
EUR Margin 1 month (Number in format 0.00)
EUR Margin 2 months (Number in format 0.00)
EUR Margin 3 months (Number in format 0.00)
EUR Margin 6 months (Number in format 0.00)
EUR Margin 9 months (Number in format 0.00)
EUR Margin 12 months (Number in format 0.00)
USD Margin Instant Access (Number in format 0.00)
USD Margin Overnight (Number in format 0.00)
USD Margin 1 week (Number in format 0.00)
USD Margin 2 weeks (Number in format 0.00)
USD Margin 3 weeks (Number in format 0.00)
USD Margin 1 month (Number in format 0.00)
USD Margin 2 months (Number in format 0.00)
USD Margin 3 months (Number in format 0.00)
USD Margin 6 months (Number in format 0.00)
USD Margin 9 months (Number in format 0.00)
USD Margin 12 months (Number in format 0.00)
I would the Rates table to have the following fields and a form/forms if needed based on this that can enter/edit/search records:
GBP Instant Access (Number in format 0.00)
GBP Overnight (Number in format 0.00)
GBP 1 week (Number in format 0.00)
GBP 2 weeks (Number in format 0.00)
GBP 3 weeks (Number in format 0.00)
GBP 1 month (Number in format 0.00)
GBP 2 months (Number in format 0.00)
GBP 3 months (Number in format 0.00)
GBP 6 months (Number in format 0.00)
GBP 9 months (Number in format 0.00)
GBP 12 months (Number in format 0.00)
EUR Instant Access (Number in format 0.00)
EUR Overnight (Number in format 0.00)
EUR 1 week (Number in format 0.00)
EUR 2 weeks (Number in format 0.00)
EUR 3 weeks (Number in format 0.00)
EUR 1 month (Number in format 0.00)
EUR 2 months (Number in format 0.00)
EUR 3 months (Number in format 0.00)
EUR 6 months (Number in format 0.00)
EUR 9 months (Number in format 0.00)
EUR 12 months (Number in format 0.00)
USD Instant Access (Number in format 0.00)
USD Overnight (Number in format 0.00)
USD 1 week (Number in format 0.00)
USD 2 weeks (Number in format 0.00)
USD 3 weeks (Number in format 0.00)
USD 1 month (Number in format 0.00)
USD 2 months (Number in format 0.00)
USD 3 months (Number in format 0.00)
USD 6 months (Number in format 0.00)
USD 9 months (Number in format 0.00)
USD 12 months (Number in format 0.00)
A menu to select which mailing lists to send from combo box. (multiple can be sent at once)
The subject for each email sent should be the ‘Mailing List email subject’ of each mailing list to be sent + todays date (eg Daily Commentary 25 October 2011)
There should be a box that can input the text body of the email – Can this be formatted text? Ie so it can be various sizes/colours/fonts etc
At the bottom of the email text if the Mailing List has Rate based list = Yes then it should automatically attach a table of Rates from the Rates table. These rates should have the margin from the Mailing List table added to it so the customer gets sent a list of rates automatically margined.
I hope this makes sense any questions fire away? For someone with good knowledge I guess the above is fairly simple.
