New with VBA, is this possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top