crreating labels

[Eden]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have recently installed Office for Mac 2008 and have imported a spreadsheet into Excel from OpenOffice.
I would now like to take some of the data from the spreadsheet and create address labels in Word. Can I do this? If so, how? If not, is there another way I can create the labels without having to type in each individual name and address, which would be in the hundreds.

 

[footsgray]

There is a tool for mail merging which will handle this situation, while the term mail merging may be misleading it is actually for merging data from a data source (Excel, Access) into a word document. You can merge letters, labels, envelopes.
In WORD 2008, if it is similar to the PC version there should a heading called Mailings.
Hope this was helpful.

 

[John McGhie]

In Word 2004, it's Tools>Data Merge. In Word 2008, they have gone back to
calling it "Mail Merge", so it's Tools>Mail Merge Manager.

Read the help on it carefully, then fire it and it will talk you through.

Cheers

There is a tool for mail merging which will handle this situation, while the
term mail merging may be misleading it is actually for merging data from a
data source (Excel, Access) into a word document. You can merge letters,
labels, envelopes.
In WORD 2008, if it is similar to the PC version there should a heading called
Mailings.
Hope this was helpful.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]