Home |
Search |
Today's Posts |
#1
|
|||
|
|||
get data from Access
I have a macro that needs a value from field in a MSAccess97 database.
The marco needs to run until EOF. I am using MSWord97. This is what I have: With ActiveDocument.MailMerge .OpenDataSource Name:=strPath & strDatabase, _ Connection:="Query qryEVM" .DataSource.QueryString = strSQL Do Until EOF 'run macro until end of records strProjectNo = .DataSource.DataFields("Project_No").Value Call DbMergeSummaries(strProjectNo) 'how to move next record??? Loop End With |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting numeric data from Access merged into a Word table | Mailmerge | |||
ODBC Iseries access - Record 1 contains too few data | Mailmerge | |||
MailMerge Word 2003 to Access 2000 query blank data | Mailmerge | |||
Mailmerge data source in an Access database will not open | Mailmerge | |||
Using as secured Access database as the data source for a mail mer | Mailmerge |