Printing address labels
Discussion
Hi there,
Not the most interesting topic i know! But...
I have a databse (Excel) in which all the addresses of clients are in one column.
I need to send out large volumes of letters to these addresses, and i was just wondering how i'g go about printing address labels directly from the spreadsheet, or what the bast way of doing it was.
I dont want to be copying and pasting thousands of addresses manually, so there must be a more direct route.
Thanks in advance
Not the most interesting topic i know! But...
I have a databse (Excel) in which all the addresses of clients are in one column.
I need to send out large volumes of letters to these addresses, and i was just wondering how i'g go about printing address labels directly from the spreadsheet, or what the bast way of doing it was.
I dont want to be copying and pasting thousands of addresses manually, so there must be a more direct route.
Thanks in advance
Open a word document - go to tools: letters and mailings: mail merge
A thing pops up on the right and walks you through it.
IIRC fairly complicated but satisfying when it works.
Sometimes, I am glad excel and word are made by the same company.
If you don't have word I guess you could format the printing page in Excel such that it lines up with your labels, but this is far more laborious.
A thing pops up on the right and walks you through it.
IIRC fairly complicated but satisfying when it works.
Sometimes, I am glad excel and word are made by the same company.
If you don't have word I guess you could format the printing page in Excel such that it lines up with your labels, but this is far more laborious.
Hi mate,
thanks for the advice, but i still cant get it to work. I've been trying for ages, but i get to a step where it asks me to insert an 'address book' and i cant get any further.
I've tried making an address list on excel and word, but it won't recognise the lists...
Any other ways of doing it?
thanks for the advice, but i still cant get it to work. I've been trying for ages, but i get to a step where it asks me to insert an 'address book' and i cant get any further.
I've tried making an address list on excel and word, but it won't recognise the lists...
Any other ways of doing it?
Which version of Word are you using? I'm using Office 2007 so can't really remember the options for V2003 and before. But the first bit is about setting up your main document, ie labels - select the right type. The second bit is about selecting your data source. Is there an option of choosing an existing list? You might need to change the file type so that it looks for your Excel document.
Also, is your data in Excel written on one line? Because if it is it might need splitting up into its components so that you can fit them on the label.
If you get really stuck you can always email me the Excel file and let me know which labels you are using and I'll set it up for you. Mail merges are a doddle when you know how!
Also, is your data in Excel written on one line? Because if it is it might need splitting up into its components so that you can fit them on the label.
If you get really stuck you can always email me the Excel file and let me know which labels you are using and I'll set it up for you. Mail merges are a doddle when you know how!
I've just looked into it, and i've actually got Open Office v2.3, and Microsoft works for the spreadsheet. I'm not very technically minded, so i'm not sure if this is the one that you are talking about!
Anyway, thanks for that information, and very kind of you to offer to do it, but i need to learn. I'm going to be doing one every week, but i need to get the basics down first.
In my spreadsheet the addresses are all written on one line. I dont mind of the address lables print the addresses on one line of text, anything is better than having to copy and paste thousands of them by hand!
so i've got my spreadsheet with all the addresses in column C (for example). How do i tell the mail merge that the addresses are there and in that column?
Thanks again and sorry for being such a technophobe!
Anyway, thanks for that information, and very kind of you to offer to do it, but i need to learn. I'm going to be doing one every week, but i need to get the basics down first.
In my spreadsheet the addresses are all written on one line. I dont mind of the address lables print the addresses on one line of text, anything is better than having to copy and paste thousands of them by hand!
so i've got my spreadsheet with all the addresses in column C (for example). How do i tell the mail merge that the addresses are there and in that column?
Thanks again and sorry for being such a technophobe!
Once you've got your main labels document looking at the correct spreadsheet (btw, you must have a heading at the top of the column eg Address), then you need to insert the merge field into your Word document, there should be an icon/button to do this and will give you the options of inserting any of the column names in your data source.
Labels are a bit more complicated because you'll insert the <<Address>> field (or whatever heading title you gave it in Excel) into the first label (row 1, column 1); format the layout how you want it to look. The next labels there should already be a <<Next record>> field already in there (which should have been inserted when you opened up your data source). Have a look at the buttons as there might be one that says something like 'update labels' or 'propagate label' and it will insert the merge fields that you've defined in the first label to the rest of the page.
It sounds a bit fiddly, and it is until you get the hang of it.
Sorry I can't be more specific as I haven't used Open Office v2.3 so don't know how that differs to 'normal' Word.
Labels are a bit more complicated because you'll insert the <<Address>> field (or whatever heading title you gave it in Excel) into the first label (row 1, column 1); format the layout how you want it to look. The next labels there should already be a <<Next record>> field already in there (which should have been inserted when you opened up your data source). Have a look at the buttons as there might be one that says something like 'update labels' or 'propagate label' and it will insert the merge fields that you've defined in the first label to the rest of the page.
It sounds a bit fiddly, and it is until you get the hang of it.
Sorry I can't be more specific as I haven't used Open Office v2.3 so don't know how that differs to 'normal' Word.
Gassing Station | Business | Top of Page | What's New | My Stuff