When saving a new data source, the only option is .mdb, which other users,
not on 2007, don't seem to be able to open. How can I force Word 2007 to
save it's data source as something other than .mdb?
thanks!
Matt
Herb Tyson [MVP] - 16 Apr 2008 13:48 GMT
I've not found a direct way to do it when initially creating a new data
source. What works... however, is to go ahead and create the .mdb file.
Then, open that file with Excel and save it in Excel 97-2003 format, which
others should be able to use (I confirmed here that the resulting file can
be used for a Word 2003 mail merge data source).

Signature
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
> When saving a new data source, the only option is .mdb, which other users,
> not on 2007, don't seem to be able to open. How can I force Word 2007 to
> save it's data source as something other than .mdb?
> thanks!
> Matt
Doug Robbins - Word MVP - 16 Apr 2008 20:36 GMT
You do not have to use the mail merge facility to create the data source.
See the article "Creating a Mail Merge Data Source" at:
http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> When saving a new data source, the only option is .mdb, which other users,
> not on 2007, don't seem to be able to open. How can I force Word 2007 to
> save it's data source as something other than .mdb?
> thanks!
> Matt