J
jonmarcr
We wrote macros to link up to one of four "mail queues" derived from our
access database. In Office 97 and then in Office 2000 they worked well but
in office 2003 we simply cannot get them to work properly.
The old syntax was:
Sub Merge1Q()
'
' Merge_1 Macro
' Macro recorded 08/05/2004 by Jon Marc
'
ActiveDocument.MailMerge.DataSource.QueryString = _
"SELECT * FROM [Qry-MAILSHOT ADDRESSES] WHERE (([Mail_Merge_1] =
-1))" & _
""
End Sub
This now gives us run time error 4198
The data source for this user is: MAIL MERGE DATA (JMR) Qry-MAILSHOT
ADDRESSES (in "My data sources" folder)
(each user has his own sub-table and so another user will have MAIL MERGE
DATA (PEC) Qry-MAILSHOT ADDRESSES and so on.
Within each table there are all the addresses selected for the 4 possible
mailshots and by manually selecting queue=-1 for either 1,2,3 or 4 we can get
it to work. However we simply want a macro to do this for us to avoid errors.
Can anyone help please?
access database. In Office 97 and then in Office 2000 they worked well but
in office 2003 we simply cannot get them to work properly.
The old syntax was:
Sub Merge1Q()
'
' Merge_1 Macro
' Macro recorded 08/05/2004 by Jon Marc
'
ActiveDocument.MailMerge.DataSource.QueryString = _
"SELECT * FROM [Qry-MAILSHOT ADDRESSES] WHERE (([Mail_Merge_1] =
-1))" & _
""
End Sub
This now gives us run time error 4198
The data source for this user is: MAIL MERGE DATA (JMR) Qry-MAILSHOT
ADDRESSES (in "My data sources" folder)
(each user has his own sub-table and so another user will have MAIL MERGE
DATA (PEC) Qry-MAILSHOT ADDRESSES and so on.
Within each table there are all the addresses selected for the 4 possible
mailshots and by manually selecting queue=-1 for either 1,2,3 or 4 we can get
it to work. However we simply want a macro to do this for us to avoid errors.
Can anyone help please?