Reply
 
Thread Tools Display Modes
  #1   Report Post  
Andrew
 
Posts: n/a
Default Using excel as a data source, but only getting 63 fields

I am running Macintosh 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 meuse 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
getting involved and coverting my excel file. When the merge file
accesses the excel file,it says that it is converting the file. I tried
checking the "confirm conversion before opening" preference, but this
has not helped. How can I stop word from converting my excel file?

(I have crossposted on microsoft.public.mac.word but not received a
response)

Thanks!

Andrew

  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

Hi Andrew,

Try saving the excel file as a .csv file (text) and then use that as the
datasource.

I don't know anything about the Mac OS or Word for it, but about 64 fields
used to be the limit in earlier versions of Word for Windows, but more
recent versions of Office have increased that to 256 fields which is the
maximum number of columns available in Excel (or fields available in an
Access database table).

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Andrew" wrote in message
oups.com...
I am running Macintosh 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 meuse 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
getting involved and coverting my excel file. When the merge file
accesses the excel file,it says that it is converting the file. I tried
checking the "confirm conversion before opening" preference, but this
has not helped. How can I stop word from converting my excel file?

(I have crossposted on microsoft.public.mac.word but not received a
response)

Thanks!

Andrew


  #3   Report Post  
Andrew
 
Posts: n/a
Default

Thanks. It worked to save as a .csv file, but screwed up the
worksheets that have links to the worksheet I am using for the merge.


Anybody have any idea how I can stop Word from converting my Excel file
into a "merge helper" file?

Thanks,

Andrew

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot Find Its Data Source Dave Foote Mailmerge 3 December 17th 04 12:27 PM
Number format from excel data source Lori IKEA Mailmerge 1 December 15th 04 11:14 AM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 10:02 AM
Mailmerge wont see Added Excel Data source Columns Thatdampwood Mailmerge 3 December 2nd 04 11:56 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM


All times are GMT +1. The time now is 02:55 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"