Re: making labels

[little...@officeformac.com]

Thanks again, John. What would I do without you!

[John_McGhie_[MVP]@officeformac.com]

After you have imported to Excel, then delete rows or columns as required,
so that the row containing the column names is the top row (with no other
rows above it) and there are no blank rows before the last row.

Word has to "guess" how big the input table is in Excel, and it does that by
assuming that the first blank row it sees is the end.

Cheers

On 12/11/09 6:48 AM, in article 59bab...@webcrossing.JaKIaxP2ac0,
"little...@officeformac.com" <little...@officeformac.com> wrote:

> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel With
> previous help from this forum, I have successfully created labels. I am now
> trying to make more but have run into problems although I think I am doing
> the same thing.
> I exported a spreadsheet from iWorks/08 (Numbers) to Excel but when I 'open
> data source' a popup says 'Word could not merge.... as records were empty'. I
> am using the same data source as before. I notice that when it converts to
> Word, the header column is numbered (2) instead of (1) and when the labels
> format comes up, the first label is blank. Any explanation?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or 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:jo...@mcghie.name