making mailing labels in Word from info in an Excel spreadsh

dhegemann · May 13th, 2002, 03:22 PM

I'm trying to make mailing labels in Word with the information coming from an Excel spreadsheet (using mail merge). My directions tell me to open the Excel spreadsheet; copy the data I want into a new spreadsheet and save that new one in a tab delimited format. Then open Word, mail merge, and choose that new file as the data source. I get an error message every time telling me Word cannot open this type of file. HELP! What am I doing wrong?

[ This Message was edited by: dhegemann on 2002-05-13 14:23 ]

stevebausch · May 13th, 2002, 03:37 PM

I have done it, it works, perhaps you are assuming you comprehend the instructions, and you are misunderstanding.

You could also do a search on "Excel mail-merge" and see what other sites have to say about the process. I checked, there are easily a dozen hits.

dhegemann · May 13th, 2002, 03:49 PM

I've done a mail merge from Excel info using these instructions many times (successfully). I'm following them to the letter as I have in the past, and this time they're not working. But thanks for your suggestion about doing another search.

AmberJo · May 13th, 2002, 06:02 PM

I don't know if I'm on the wrong track here- but here's what I do (best to print instructions and click through- they'll make better sense that way.-

Open a new word doc.
Tools, mail merge
Create, mailing labels, active document.
Get data, open data source, there's a 'files of type' drop down list- scroll it down so it says 'all files', then find your excel file in your system and click 'open'.
An error will appear saying that you need to insert merge fields into main document. Click setup main document, pick your label types (codes are on the box of labels) then go through and insert merge fields (eg name, address 1 etc) into a sample label. Click OK, then merge (I always pick a new document).

Hope this helps.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 03:22 PM	#1
dhegemann New Member Join Date: May 2002 Posts: 2	I'm trying to make mailing labels in Word with the information coming from an Excel spreadsheet (using mail merge). My directions tell me to open the Excel spreadsheet; copy the data I want into a new spreadsheet and save that new one in a tab delimited format. Then open Word, mail merge, and choose that new file as the data source. I get an error message every time telling me Word cannot open this type of file. HELP! What am I doing wrong? [ This Message was edited by: dhegemann on 2002-05-13 14:23 ]

May 13th, 2002, 03:37 PM	#2
stevebausch Board Regular Join Date: May 2002 Posts: 809	I have done it, it works, perhaps you are assuming you comprehend the instructions, and you are misunderstanding. You could also do a search on "Excel mail-merge" and see what other sites have to say about the process. I checked, there are easily a dozen hits.

May 13th, 2002, 03:49 PM	#3
dhegemann New Member Join Date: May 2002 Posts: 2	I've done a mail merge from Excel info using these instructions many times (successfully). I'm following them to the letter as I have in the past, and this time they're not working. But thanks for your suggestion about doing another search.

May 13th, 2002, 06:02 PM	#4
AmberJo New Member Join Date: Apr 2002 Location: Uni Credit Union Posts: 17	I don't know if I'm on the wrong track here- but here's what I do (best to print instructions and click through- they'll make better sense that way.- Open a new word doc. Tools, mail merge Create, mailing labels, active document. Get data, open data source, there's a 'files of type' drop down list- scroll it down so it says 'all files', then find your excel file in your system and click 'open'. An error will appear saying that you need to insert merge fields into main document. Click setup main document, pick your label types (codes are on the box of labels) then go through and insert merge fields (eg name, address 1 etc) into a sample label. Click OK, then merge (I always pick a new document). Hope this helps.