Transfering Addresses from excel to word

INSman · May 8th, 2002, 08:52 AM

i want to be able to take these 900 addresses that i have and transfer them to word to print mailing lables. Data ranges from A1:H1. fname, lname, address1,address2, blahh blahh... Is there a macro, or an option to do this that i just don't know about? Please help
i want them in a different format, not just copy and paste

-andrew

[ This Message was edited by: INSman on 2002-05-08 11:55 ]

klb · May 8th, 2002, 11:21 AM

Maybe this is too obvious but:

Copy the data range including the field names that you want.
Open Word and paste the cells.

Sam40mUK · May 8th, 2002, 12:47 PM

Hi,
I would suggest leaving the data in Excel, give the columns appropriate headers,
Name, Surname, Address1, Address2, etc..
Goto Word - Tools - Mail Merge - Main Document Mailing Labels - Get Data .. Open Data Source - browse PC for Excel file - Open File .. (try Entire Spreadsheet option) Set up Main Document check settings OK .. Insert Merge Fields on next screen .. Then Merge
I hope this rather disjointed explanation gives you an idea that it is possible. Have a go and if you get stuck please post again.
Regards
S

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

May 8th, 2002, 08:52 AM	#1
INSman New Member Join Date: May 2002 Posts: 4	i want to be able to take these 900 addresses that i have and transfer them to word to print mailing lables. Data ranges from A1:H1. fname, lname, address1,address2, blahh blahh... Is there a macro, or an option to do this that i just don't know about? Please help i want them in a different format, not just copy and paste -andrew [ This Message was edited by: INSman on 2002-05-08 11:55 ]

May 8th, 2002, 11:21 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Maybe this is too obvious but: Copy the data range including the field names that you want. Open Word and paste the cells.

May 8th, 2002, 12:47 PM	#3
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Hi, I would suggest leaving the data in Excel, give the columns appropriate headers, Name, Surname, Address1, Address2, etc.. Goto Word - Tools - Mail Merge - Main Document Mailing Labels - Get Data .. Open Data Source - browse PC for Excel file - Open File .. (try Entire Spreadsheet option) Set up Main Document check settings OK .. Insert Merge Fields on next screen .. Then Merge I hope this rather disjointed explanation gives you an idea that it is possible. Have a go and if you get stuck please post again. Regards S