Excel Mailing List Labels
What is the easiest way to make an Excel based listing of names and addresses off a list on the Internet?
Am I going to have to type it all out to get it on excel…or is there some software or tool that I can use to read it off the web and put it into an Excel spreadsheet.
I want to make a list of the names and addresses of all the state politicians and then use it in Excel to print mailing labels.
Depending on how the list is formatted on the web site, you may be able to copy the text and then paste it in Excel and then use DataText To Columns to separate the data into separate cells. This may be difficult because addresses are widely variable in their formatting.
You might also try using…
DataImport External DataNew Web Query
…to import the data from the web site.
.
Caught on tape: Supposedly user-friendly label printing foil