Question about Computers & Internet

1 Answer

Mail Merge how do I print mailing address labels from an XL database, want the steps to a mail merge

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 11 Answers

I assume XL means, Excel...what version are you using of office?

Posted on Mar 19, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How may I do a return address label--all 30 labels on 5160 Avery template without typing the address 30 times


Hi Jan,

You can use the option Mail Merge In Microsoft Word to print Return address.

If you are Using Windows 2003, Follow the link below

http://www.wikihow.com/Mail-Merge-in-Microsoft-Word


If you are using Windows 2012, You will find Mail Merge option under Mailing tab on top - Create Mail Merge option

Regards,
Sean

Apr 22, 2013 | HP Officejet 6310 All-In-One InkJet...

1 Answer

How do I print just one mailing label without running through an entire sheet time I print using an Epson LQ-590 and printing from the mail merge option in MS Word (MS XP)? In other words, when I print...


I assume you are using a sheet of labels, such as the typical 3 x 10 sheet. Word sets up the mail-merge document for printing the whole sheet, so if you print just one or two labels, you will `waste' the rest.
One way of using that sheet over is to create a mail merge that contains blank `dummy' addresses. It is rather involved and at best time consuming, and considered not worthwhile to save a partial sheet.
I service printers, and personally do not recommend that any label sheet be re-used. The printer curls the paper, in some cases fuses it, and causes the corners of the labels to be exposed, and possibly get caught in the printer (I have removed a lot of labels from inside printers)

Oct 18, 2010 | Office Equipment & Supplies

1 Answer

Word 2007 problems with mail merge labels


YES, you have conflict with other program installed. Reinstall will not solve the problem, great solution is upgrade your Microsoft Office from 2007 to 2010 and surely you can print all the document once it is change to new office 2010.

Nov 23, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

I am having problems with a mail merge for tent card 5302 - can someone tell me how to merge an exisiting excel document into word?


In Word 2003:
Open the Tools Menu >> Letters and Mailings >> Mail Merge.
Select Labels and click Next
Click on Label Options and select your tent card and click OK and then Next
Select Use Existing List and click Browse to find your Excel document. Click Next.
Add in the fields you want on your cards to the first and then click Update All Labels.
Finish Mail Merge Wizard.
-- Word 2003 doesn't come with the 5302 label template. You'll need to download that from http://support.microsoft.com

In Word 2007
Select Mailings from the menu list at the top,
Click on Start Mail Merge and select Labels
Select Label vendor Avery US Letter
Select your product number 5302 and click OK
Click on Select Recipients from the top and select Use Existing List to browse to your Excel document
Using the buttons on the top for Address Block/Greeting/etc add in the fields you want to the first label.
Click on Update Labels
Click on Finish and Merge

Apr 28, 2009 | Computers & Internet

1 Answer

M/s Works 8.5 labels printing blank fields


when you choose print there is a Mail Merge option that says "Don't print lines with empty fields" (company name, address line 2, etc.). check this box before sending to printer

Feb 22, 2009 | Microsoft Works 8.0 for PC

1 Answer

Printer will print everthing but labels from Word mail merge


did you set up a lable templete for the lable???
when yo do amail merge, you need to go through the trouble of seting up a mail label templet in accordance to the label you are going to use.

Dec 11, 2008 | Kyocera Mita KM-2050 Printer

2 Answers

Mail Merge won't print


AppleWorks is a quirky and hopelessly outdated product. I am aware that a few people have an extreme fondness for it however.
It should only have taken minutes to import data, but don't do it in AppleWorks - they stopped making it years ago and it is unsupported and non-standard.
I have just taken two AppleWorks databases, - one older and one newer that needed to be combined. I exported them as tab delimited text and then imported them into Excel (You could use Apple Numbers - the modern equivalent to AppleWorks). Because the to db's had different headers, I imported them into two different Excel docs first and moved the columns around so the matched first, them copy each column over to the 'master' excel sheet.
You can either use the basic database tools in Excel, or once your data is combined and in this kind of data form, it is easy to import a .xls, or .csv into a new database program, such as Filemaker.
If you do copy over the data to Excel, any merge function - for label printing etc. has to be done in Word (or at least up to Word 2004). I was thrown by this until I realised you have to do this. Once a merge doc is set up with the right labels, it worked beautifully. Typical MS though it is a wholly unintuitive process.
Copy and importing data should be done with attention to care obviously. Make sure you have your original AW files backed up before you start.

May 20, 2008 | AppleWorks 6 for mac

4 Answers

How to create mailing labels in Microsoft Works


With a Microsoft Works Word document open, select: Tools>Labels>(the list of available label types will pop up, select the label sheet you're using) then select: Tools>Mail Merge>Open Data Source...

Don't know how it could be simpler.

Dec 18, 2007 | Microsoft Works 8.0 for PC

1 Answer

Mail Merge Print Problem


Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

Dec 05, 2007 | Dell Latitude D800 Notebook

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

84 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...