What is the best way to tackle my new project for lead and warranty entry??

[gg3115]

I was just awarded a new project. I need to figure out a way to link a Lead (new customer) to an existing dealer by zi pcode. Then once dealer is paired with lead export those to word mail merge. I also need to have a macro that once you enter in a zip code it will bring up the dealer that matches the dealers zip code. Please help!

[orange]

What part exactly is causing difficulty?
Have you identified the steps (logic) in plain English of what you need to do?

eg:

Display Dealers in zipcode X

Do you have a table that has

DealerID
DealerName
DealerAddress1
DealerAddress2
DealerCity
DealerState
DealerZip

Plain English:
Find the Dealers whose zipcode = "X"

Essence of the query in SQL

SELECT Dealer.* from tblDealer where DealerZip = "x" '

Good luck