Posted by: Dignan
Looking for ideas - 21/10/2008 13:18
Here's the situation:
I'd really appreciate any help with this. I'm not even sure where to get started...
ps-I've attached a sample of the kind of spreadsheet Company #2 receives
- company #1 has a web site with a form on it
- it gives all the data collected from the form to company #2 in the form of the occasional Excel spreadsheet
- the data includes the usual info like name, address, email, etc, and an opt in or out field
- company #2 is looking for a way to more or less automate the handling of these spreadsheets they receive
- if an entry on the form has both an email address and an "IN" in the "Opt" field, they want to send that person and email
- the email will contain standard text (no need to fill in from other fields in the spreadsheet) and a few PDF attachments
- the spreadsheets are always arriving, so there would need to be a way to tell if an entry had been sent an email already - this might be difficult in an automated system
- I am very inexperienced with Access
- it might be easier in the long run to simply order each spreadsheet as you receive it so that you only saw emails and opt ins, then just copy and paste all the email addresses into an email and send it
- plug in the new spreadsheet
- click a button to send the email to everyone who hasn't gotten it yet
I'd really appreciate any help with this. I'm not even sure where to get started...
ps-I've attached a sample of the kind of spreadsheet Company #2 receives