Quote:
|
Originally Posted by Shanatink 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  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.