Mail Merge?
 

How in the heck do you do a mail merge in Microsoft Word 2003? I have a database in excel that I am trying to do a mail merge in Word so that I can print address labels but I cant seem to get it to work when I follow the step by step instructions that they offer in word. :(

Its making me crazy!

I have no clue but i'm sure someone knows LOL

Ok, in Microsoft Word 2003, go to Tools on the toolbar, then Letters and Mailings, then Mail Merge. It is a Wizard-type deal. Just select Labels, then label options to select the label size, then when selecting recipients choose "use an existing list" and just browse to your excel document.

:thumbup: :thumbup: :thumbup:

to add to this ...you can also go to Tools - then Mail Merge - Create Document (Create or Edit) then Click Data Source and you'll see your Excell files in the drop down menu

I use Microsoft Outlook to do mail merges and it's pretty easy.

This is what I did yesterday and for some reason it woulnt work. It acted like it would work but in step 4 or 5 (cant rememeber which one) it says preview label and nothing would show up :confused: So I dont understand why :(

Hmmmm......Do you have your Merge fields correct ?

I just copied these directions from my Excel program - See if this works - you said you followed the directions in Word - this is just going the other way - Excell TO Word

Open the Word main document that contains the standard text for the form letter or other document you want to merge with the list. If you're starting a new document or printing mailing labels or envelopes, click New to open a new blank document.

On the Tools menu in Word, click Mail Merge.


Click Create, and select the type of document.


Click Get Data, and then click Open Data Source.


In the Open Data Source dialog box, open the folder that contains your Microsoft Excel workbook.


In the Files of type box, click MS Excel Worksheets (*.xls).


Double-click the workbook that contains your data.


In the Microsoft Excel dialog box, select the named range, or type the cell references that identify the data you want to use, and then click OK.


When Word displays a message, click Edit Main Document or Set Up Main Document.


If you're creating a form letter, use the Insert Merge Field list on the Mail Merge toolbar to insert merge fields within the standard text.

When you finish, click Mail Merge Helper on the Mail Merge toolbar.

If you're printing address labels or envelopes, select the printer and the size of address labels or envelopes. Then insert the merge fields in the Create Labels or Envelope Address dialog box.

In the Mail Merge Helper dialog box, click Merge, and then select the options you want.