Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB & Word - mail merge with ODBC

Status
Not open for further replies.
oka97

oka97

Programmer
May 25, 2003
28
0
0
GB
It seems only Word 2002 (XP) allows u to choose the datasource as ODBC as an option..

Has anyone here figured out how to use ODBC with say Word 2000 or 97?

Otherwise I guess I'm going to have to use a direct link to the mdb file.
 
Sort by date Sort by votes
Hey there

When setting up a mail merge in Word 2000 you have the option of selecting MS Query which in turn allows you to select the ODBC Data source required. When you select "Get Data" and "Open Data Source" you can click on the "MS Query" on the file box.

Hope this helps !!!
 
Upvote 0 Downvote
Thanks so much hookbob.

I just ended up using a DSN-less connection.

I provided a form to the user to specify where the mdb was located (and the mail merge .doc's).

All works lovely :)

Got it printing labels on avery paper nicely too.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
merge two cell in one in a msflexgrid
Replies
1
Views
77
strongm
strongm
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
191
strongm
strongm
tomminil4
  • Locked
  • Question
Help with VBA code
Replies
3
Views
116
strongm
strongm
Niki_S
  • Locked
  • Question
How to merge two variables into one in VB 6? 1
2
Replies
22
Views
182
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
89
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top