New with VBA, is this possible?

J

JohnL

Not too familiar w/ VBA (been a long time since I dabbled). Is this possible?

I have a list of email addresses in an Excel spreadsheet in column A called
"Email". I have an Access database called MarketDB with a table called
"Contact" that has a column called "Email" and a column called "Status".

I would like to write a macro that would:
1) check the email address in Excel (first one is in cell A2),
2) check the Email column in Access for a match,
3a) if no match, go to next email in Excel -- 3b) if there is a match, then
delete the email listed in Access and move over to the Status column and
select Opt-Out from a picklist (there are 5 total options in the picklist;
Opt-Out is the fourth option),
4) go to the next email in Excel and repeat the process until there are no
emails left in Excel column A.

So I guess my question is: 1) is VBA capable of this, 2) can anyone point me
in the right direction to get started?

Thanks for taking the time to read this. Hope it makes sense.
John.
 
D

Douglas J Steele

It's certainly possible.

However, what I'd recommend is linking to your Excel spreadsheet (under File
| Get External Data | Link Tables) and writing queries to do what you want.
 
Top