PDA

View Full Version : Mail merging addresses from notepad


AirSupplies
11th April 2010, 17:53
Hi, just a quick one. I have a few addresses in notepad like this:



Station Yard, Station Road, Melbourne, Derby DE73 8HJ

Common Lane, Watnall, Nottingham NG16 1HD

Private Road 2, Colwick Industrial Estate, Nottingham NG4 2JR



How can i get these printed out onto address lables? Just mail merge them into word and print? Or do i need to put them into an excel file first. I hope not!

Cheers

Postforce
12th April 2010, 11:35
Hi there

Should be easy enough. Copy the rows in to excel. Highlight column A, then go data - text to columns with your delimiter as ,

Good luck!

FBtips
12th April 2010, 18:25
If its just a few address, you should be able to just use Word itself, just go to 'Tools' and select labels option, it shud create a kinda template and you can type in all your addresses in each template and just print!