i finally got all my mailing lists in excel so now i need to print labels?  do i have to import them into word (if so how?) or can i print them in excel(again if so how)
136879
First of all, make sure your lists in Excel have headings on the columns.  For example, line "A" needs to say First Name, Last Name, Street City, State, Zip, etc.  This tells Word what type of info it is looking at. Do this to the best of your ability, depending on how you set up your sheet.  If you combined some of it, don't worry and then follow the next steps...\n\nOk, go into Word and choose "Tools" "Letters and Mailings" and "Mail Merge."  When the mail merge wizard opens on the right, choose "labels."  Click "next"  Then choose label options.  Go in and tell it what type of labels you are using, etc.  You should be able to choose the Avery Label and # so it knows what it is printing on.  Then click "next" It should open up a page of blank labels and your next step should be choosing recipients.\n\nClick the "browse" link under "existing list" in the "select recipients" page.  Go through the browse and open your Excel mailing list.  Once you select that, you click "next" to arrange your labels.   There will be a group of options such as "address block" "greeting line" etc. on the right. Set up your "address block" on your labels by clicking the link then positioning it on the label where you want it.\n\nThen, choose the "more" link under the "address block" "greeting line" etc. and a window will pop up.  There will be a button it it that says "Match Fields."  Yours may work a little differently, but you need to find the "Match Fields" in case you need to tell Word which columns in your spreadsheet conatain what info.  For example, if you put the city, state, and zip in one column, you can go in and tell it to use that column for that part of the address.  This is where you tell Word which info to use for the labels.\n\nOnce you get all that meshed correctly, you should be able to preview your labels and all should be well.  If not, check back into the arrange labels part and fix what you need to fix.\n\nI hope that helps!
288311
This is a quirk that happens all the time in mail merge between Excel and Word.  One way to fix this is convert the Excel field you are merging to text.  \n\nSo instead of merging in a column containing 9.8, you would merge in a column containing text representation of the number column.  Use the TEXT() function in Excel to convert the numbers to text, then use that column in your merge field instead.  This way you can insure that everything you bring over to Word is text, rather than a number.
298488
You can use classes defined in  Microsoft.Office.Interop.Excel or Microsoft.Office.Interop.Word to export and format your data in to an Excel or Word file. Then you can print them from it.
30758
Your best bet is using the Mail Merge feature of Office. You enter the names and addresses into Excel and have them automatically drawn in to your letter template created in Word.\n\nCheck out this link for a quick tutorial:\nhttp://office.microsoft.com/training/training.aspx?AssetID=RC011205671033
212651
Sure! Start with the templates available right inside your word processor, check the packaging from your labels. There may be a website to download from or even a mini-CD. Generic or custom sizes can be entered into websites such as avery, mead, daytimers, franklinplanners, etc., etc.
108677
There are several answers to that, depends on what you want to print. I recommend you check out Microsoft Access help menu - Contents and Index option and type in Print in the search window.\n\nThere is a print method for reports:\nobject.Print [{Spc(n) | Tab(n)}][expressionlist][{;|,}]\n\nThere is a print statement:\nPrint #filenumber, [outputlist]\n\nYou can print a range:\nobject.Min [= points]\nobject.Max [= points]\nobject.Min [= number ]\nobject.Max [= number ]\n\nYou can create a print button with this code:\nDoCmd.OpenReport DocName, acViewNormal\n\nYou can copy and paste large bits of code into MS Word, Notepad, Wordpad or other text editor then print it from there\n\nYou can write output to a txt file:\nWrite #filenumber, [outputlist]
503450
Hi! Okay, if you want to add it as an option just follow the steps below!\n\n1. Open the control panel.\n2. Select Printers and other hardware.\n3. Click add a printer.\n4. Click next to continue.\n5. Select 'Local Printer' and check the automatically detect option.\n6. Click next to continue.\n7. Click next to continue.\n8. Choose Microsoft Document imaging writer port when asked to choose a port to use.\n9. Click next to continue.\n10. Select generic as the manufacturer and select generic / text only as the printer.\n11. Click next to continue.\n12. Name the printer "Microsoft Office Document Image Writer".\n13. Select Yes if you wish to use it as your default printer.\n14. Click next to continue.\n15. Choose whether you want to use it as your default printer.\n16. Click next to continue.\n17. Choose whether you want to print a test page.\n18. Click finish to complete the wizard.\n\nI hope this works for you, if you have any problems just post and I will try to help out!
313103
In MS Word, there are two main ways to print on envelopes or mailing labels. If you want to enter the information for each address, then use Tools > Envelopes & Labels. If you want to do a bunch, use Tools > Mail Merge. There are wizards and prompts to help you from there.
626791
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
511522
Highlight the text then go to file print that should work depending how your printer is set up copy and paste it into word, then print. Did you try to highlight then go to file, print, then select "selection". You have to do all steps for it to only print the one line. Maybe you did do this, I know I have forgot to select "selection" before myself.
81153
how about using that 30page excel file as a main and insert the word file into excel.\nor find last year file to find out how if its still there.
355911
Get sticker paper and put it in your printer, then use Microsoft Word to print them up.\n\nThere's a way to set it up especially for printing stickers.\n\nThere are also many other programs that can be downloaded (or may already be on your computer) if you don't have Office.
319372
1) Do you have a printer?\n2) Can you print other stuff?\n3) What do you use to see the invoice on screen (Word, Excel ... Internet Explorer)?\n4) Can you print other things from that package?\n5) Contact Kleeneze
215173
Highlight all of the text you would like to print (do this by click and drag method). Right click on the highlighted text and select print. When the print properties come up, choose selection, then print.\n\nWhy?\nSome browsers confuse HTML resources and don't print the actual text, just the header and footer and sometimes menus, especially when java or flash is involved. Hope this helps!
550744
i had to make a pamphlet for school once.  I'm not sure of an easier way, but you can make columns on a word document in the format option.
588252
Because Excel has separate page settings per a sheet. We need to make sure the "print in black/white" is unchecked per every sheet and not just the first sheet.\n\n1) Right-click any sheet\n2) Select "Select all sheets"\n3) Go to File/>Page Setup\n4) Go to Sheet tab\n5) Uncheck black/white if it's checked\n6) Click ok\n7) Go to Print Preview and see if we fixed it
52049
There are several ways to go about this, depending on how you have already entered data and what exactly you want it to look like.\n\nDid you already enter data into Excel?  Is it in the format: 9'3", 9'4", etc.?\n\nIs this data entered along a row (across) or a column (vertical), or some other layout?\n\nDo you want Excel to show the data in that same format (i.e. 9'3") or do you want it to say something like 9.25 ft?\n\nAny oher specific information I should know about what you're trying to do?  This way I can give you a useful answer.