I have an excel spreadsheet that needs converting...?

You can actually create a labels effect with out the grid lines printing. You'll see the lines appear on the screen but they won't print unless you create cell borders.

You don't mention what version you're using...that would be helpful. But since I have MSW03 (Ms Word 2003) and am most familiar with that, I will use MSW03 as reference.

You can print label format on paper, not adhesive labels. The only difference is you're putting paper in the printer, not labels.

HELP: IF ANYONE WITH MS WORD 2007 KNOWLEDGE KNOWS HOW TO DO THIS, YOUR ANSWER MIGHT BE HELPFUL TOO! :-)

So here's the MS 2003 "how to" version:

1) in excel, create separate colums for first name, middle name or initial, and last name, and another info you would like such as year, spouses name, etc...once you're finished with this file, SAVE and CLOSE it. Don't forget what you named it and where you saved it; you will need to know this later.

2) in MS Word (if you have 2003 version) open a clean document, go to TOOLS/LETTERS & MAILINGS/MAIL MERGE

3) in your mail merge pane that opens (probably on the right), select LABELS then down below that should be a blue link that says "Next...) click on it. (((The next several steps below will take place in this same mail merge pane.)))

4) select change document layout. You'll also see Label options, if you click on that, you an select thge style of labels you want.

5) click on the link "Select Recipients" and in teh next window select "Use Existing list" and below that select browse and go to the excel file you want to merge and click on it as if to open it.

6) the nedt window that opens shows you all the records in your excel file. If there are some you wish to omit, de-select the check box. When finished, click ok.

7) in the lower part of your mail merge menu pane click the link "Next: Arrange your labels" then the next part has several different links, click MORE ITEMS to get the headers you created in your excel file.

8) After you've clicked "More Items" you can go back to your Word document and put your cursor in the very first cell (the one that's all blank) This is where you can select and arrange the headers the way you want the real information to appear in the word document.

For instance, select FIRST NAME (then click select) then go to the word document and time a space then go back to your selection screen and select the middle name/ initial or LAST NAME or whatever you want, then press SELECT, when you're finished with this line, go to the word document and press ENTER to get to the next line to add the address or whatever it is you want. Continue this with all the information you want to add on that person...careful, space is limited.

9) highlight all those headers in your first cell and copy/past them into the rest of your cells AFTER the << NEXT RECORD>> indicator...do NOT delete this indicator....NOTE...if you have hundreds of records, it would be helpful that after you've completed one whole row like this to to copy and past the entire row to the next row below. Be sure the first row you copy has each cell the same...that each cell begins with <<NEXT RECORD>> then has all the header info you want. Best advice: copy and paste row 2 like crazy. Have hundreds to paste to? Just hold down CNTRL V and let the program continue pasting like crazy.

OK...you're almost finished here!

10) Click UPDATE ALL FIELDS then click the link "Preview your labels.

11) VIOLA! That's wasn't so bad was it? It takes some getting used to. Now just click "NEXT Complete Merge"

I hope this was helpful. I gave you step by step help as I was doing it myself so I knew exactly what to say.

Again, hope this was helpful..

Good luck and have fun!

Right click on the top of the column in Excel to format the whole column as text or number and make them all have the same decimal value. If you have both types of data (text and numbers) in the same column, that could be the problem. I prefer importing rather than linking so I can't really comment other than I don't have those kind of problems. If you planning on building a data entry form in Acces, it is possible to export the same form to Excel, but I don't see a reason to have to maintain two data bases.

Mail merge into word then use an Avery form and print it on plain paper.