Publisher and Access

[Frank]

Through trial and error, I can get our newsletter mail merge done. However
there must be some simple instructions out there somewhere. My basic problem
is I do not understand the various types of data sources. I browse for a
data source and come up with six or eight technical names. I find that
clicking on jet 4 lets me get into the access data base, but that was just a
lucky guess. Is there any basic information that could help me?

 

[Mary Sauer]

Publisher lists are Access databases, in Office 2002-03 they are stored in "My
Documents", "My Data Sources" with a .mdb extension. Excel uses an .xls.
Mail and Catalog Merge data sources used in Publisher
http://office.microsoft.com/en-us/assistance/HP030713471033.aspx

 

[Mary Sauer]

Open the control panel, open the Administrative Tools folder, double-click Data
Sources (ODBC) and take a look.

 

[Ed Bennett]

Is there any basic
information that could help me?

What version of Publisher are you using?

 

[Ed Bennett]

Frank said (via e-mail):

Version is 2003 (Part of Office Professional 2003)

It looks like you are clicking the "New Source" button in the My Data
Sources folder when asked to select a data source.
You are actually able to just browse to the database (click the Up Arrow
icon to go up to your My Documents folder) and select it in the Select Data
Source window, withot the complexities of working out which data engine to
use.