Hi
I need to create a mailing list to produce labels
The data is automatically launched in Excel from a website which lists names and addresses in columns.
I then need to write some sort of query to lookup part or all of the postcode and match them to a distributor. Some of the distributors cover a whole postcode (like EG2) and some only cover a street so I have to be able to write in some kind of, if "whole postcode" isn't in the list then match "part postcode"
Now I'm a little torn between excel and access, but I'm thinking excel at the moment because I was going to use a vlookup.
I'm a little confused as to how I can do the part/whole postcode element though, what is the syntax for a query of that kind?
More importantly, how can I make it "idiot proof" so I can give this to anyone to do? Macros perhaps?
thanks
Tash
Bookmarks