Transfering Addresses from excel to word

[INSman]

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]

Maybe this is too obvious but:

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

 

[Sam40mUK]

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