Mail Merge using excel

[asrichman]

I am running OS 10.2 and using word and excel for OSX. I want to do a
merge with an excel worksheet as my data source. It will only let me
use 63 different data fields. How can I fix it so it will see more. I
know this is possible and it has something to do with the merge helper,
but I don't know how to do it.

Thanks!

Andrew

 

[Paul Berkowitz]

I am running OS 10.2 and using word and excel for OSX. I want to do a
merge with an excel worksheet as my data source. It will only let me
use 63 different data fields. How can I fix it so it will see more. I
know this is possible and it has something to do with the merge helper,
but I don't know how to do it.

I have no problem seeing all 78 fields here. I tried with both an .xls and a
tab .txt version and they both worked: all fields available. They were all
in one worksheet, mind you. Do you have a blank column after the 63rd?

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Andrew]

Nope, no blank column. My list of fields that I can insert just stops
after number 63, even though I have many more in my excel file. I have
noticed that whenever Word imports data from the excel file it says,
that it is "converting" the file. I assume this is where I am losing
the data, but I don't know how to stop it from doing this.
Thanks,

Andrew

 

[Paul Berkowitz]

Nope, no blank column. My list of fields that I can insert just stops
after number 63, even though I have many more in my excel file. I have
noticed that whenever Word imports data from the excel file it says,
that it is "converting" the file. I assume this is where I am losing
the data, but I don't know how to stop it from doing this.

What sort of Excel file? What's the extension? Was it made in Excel Mac or
Windows? Does it have more than one worksheet?

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Andrew]

I'm using Excel X and running OSX 10.2 The excel file has an .xls
extension. It has more than one worksheet, but the one I want to use
for the merge is the first one.

It works fine if I save the Exel file as a tab separated text file, but
this messes up files that have links to my spreadsheet, so I am trying
to avoid it.

Thanks,

Andrew

 

[Elliott Roper]

I'm using Excel X and running OSX 10.2 The excel file has an .xls
extension. It has more than one worksheet, but the one I want to use
for the merge is the first one.

That should 'just work'. When you open the .xls as a data source in
Word's merge manager, don't you get a little dialog box that asks for
which sheet(s) and then goes for an optional cell range for bonus
points?

That's what happens round here, where my address book is maintained in
Excel and the (hand crafted) letter templates reference it.