|
Welcome to the YorkieTalk.com Forums Community - the community for Yorkshire Terriers. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. You will be able to chat with over 35,000 YorkieTalk members, read over 2,000,000 posted discussions, and view more than 15,000 Yorkie photos in the YorkieTalk Photo Gallery after you register. We would love to have you as a member! Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please click here to contact us. |
|
| LinkBack | Thread Tools |
08-21-2006, 06:43 PM | #1 |
Mommy to 3 Princesses Donating Member Join Date: Apr 2005 Location: DFW Texas
Posts: 11,030
| 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!
__________________ Custom Dog Clothing Boutique www.TinkerbellsCloset.com |
Welcome Guest! | |
08-21-2006, 06:51 PM | #2 |
Peeka Boo I See You! Donating Member | I have no clue but i'm sure someone knows LOL
__________________ |
08-21-2006, 07:41 PM | #3 |
I heart Hootie & Hobbs Join Date: Jan 2006 Location: USA
Posts: 7,149
| 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. |
08-22-2006, 03:15 AM | #4 | |
Yorkie Kisses are the Best! Donating Member | Quote:
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. | |
08-22-2006, 03:25 AM | #5 | |
Mommy to 3 Princesses Donating Member Join Date: Apr 2005 Location: DFW Texas
Posts: 11,030
| Quote:
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
__________________ Custom Dog Clothing Boutique www.TinkerbellsCloset.com | |
08-22-2006, 03:40 AM | #6 | |
Yorkie Kisses are the Best! Donating Member | Quote:
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. | |
Bookmarks |
|
|
| |
|
|
SHOP NOW: Amazon :: eBay :: Buy.com :: Newegg :: PetStore :: Petco :: PetSmart