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?

go google and type in --user manual for excel--
there is a pdf version for download , around 900 pages which explains in detail everything you need to know on how to do what in excel
there are shorter version that deal with specific topics so cruise the sites until you get exactly what you want

Hello there!
Here is the tempalte for the 5302 tent cards http://www.avery.com/avery/en_us/Templates-%26-Software/Templates/Cards/Note-Cards/Mini-Card-_-Wide-4-per-sheet_Microsoft-Word.htm?N=0&refchannel=c042fd03ab30a110VgnVCM1000002118140aRCRD
You will be using microsoft word to type in what you need to. Here is a tutorial on how to use the templates. http://www.avery.com/avery/en_us/Templates-&-Software/Templates/How-to-Use-Templates.htm
Hope this helps! Click on the thumbs up if it did!

Hi there !

For printing bulky letters or documents of the same format, I suggest you use the MS word mail merge document. You need to set up the mail merge document and the data of the file. For examples, the list of names, addresses telephone numbers and others should be input to the envelops.

Here's how to create mail merge document file.


1. Open a new blank MS word document or if you have a format already in a MS word format, just use it as default letter.

2. Go to menu bars (Home, Insert, Page Layout, References, Mailing, Review and View) and choose Mailing.

3. From Mailing, click on select recipients, choose use existing lists and find the excel document files that stores all the information like list of customers, company names, addresses, telephone numbers and others.

4. Open it and select table will appear and just click ok to merge it automatically to your default envelope.

5. Now you need to set up or format your envelope. from the Mailing menu, Insert Mail Merge Field will appear and click it to display the headings of your data source. Put the headings wherever you want.

6. After that, press preview result to display the datas. Save your work and it is finished

7

Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Hi. I was pointed to a change in settings in Word that allowed the data to come over as I wanted.


Take care, Dennis

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.

Have you tryed this?
http://spreadsheets.about.com/b/2007/11/06/merge-spreadsheets-in-excel.htm

Use this link for pivit tables
http://office.microsoft.com/en-us/excel/HA010346321033.aspx

Use this link for Mail Merge:
http://www.excel-tutorials.org/worksheets/how-to-create-a-mail-merge-using-microsoft-excel-and-word/

hola

If you follow the Mail Merge instructions built into Microsoft Word's Mail Merge Wizard, you can use your Excel file as the data source for your Mail Merge document, which can be created using label templates built into Word or downloaded from the label manufacturer's website. If you need more detailed instructions, please let us know what version of Microsoft Office you're using, as well as the Operating System (PC or Mac, Windows '98, XP, Vista, Leopard, etc.) and the label manufacturer and label name and product number. Please let us know if you need more help.