Calling all Microsoft Word Experts
I’m in serious need of a Microsoft Word expert! I have a project at work, and I have to make mailing labels. Easy enough to do in Word, but I have all of this information already in a spreadsheet! I have figured out how to merge this information to a label sheet *IF* I were using a traditional mailing address format. I, however, am using simply first name, last name, and a mail code. I can get the labels to pull the name, but not the mail code. I will type out all the labels if I have to, but something tells me that someone, somewhere knows how this can be done. If you need more information to help, please let me know, and I’ll explain more.
I really don’t want to have to type out the labels because Word doesn’t seem to be capable of reorganizing the labels (say, if I need to add 3 or 4 employees to the list) at a later date and time. You either add them at the end, or you start over to have your order right. Boo… am I making this too difficult? It’s possible… Word and I have arguments sometimes.
July 26th, 2007 at 5:07 pm
Jennifer, I use the free templates from Avery on those rare occasions when I do labels. I think they have merging programs for mailings lists in their free software. If you’re using a different brand of labels, just find the right size. Anyway, it worth checking out: http://www.avery.com/us/software/index.jsp
Hope this helps! Oh, and there are label programs in Microsoft Works, too. You may already have those on your computer.
July 27th, 2007 at 4:53 pm
I am not sure what version of Word you are using. Go to VIEW – Toolbars – Mail Merge.
The first icon on the left is SETUP DOC and one of the options is labels. Select it and pick out the label size and setup. The next icon on the left of the tool bar is OPEN DATASOURCE. Once you have the label document and the source document open, it should be real easy to do what you want.
If you did not use a spreadsheet that is an Office product, you will need to export the data in csv file (txt). Then you will do the save as above.
Good luck.