Maiol Merge from Access

[Guest]

I recently upgraded from Windows NT4 to Server 2003 with Windows XP Professional Workstations. I use a Microsoft Access Database for member records and from that database we were able to successfully perform a mail merge using Office Professional 2000 with the following code. However we are unable to do the same with Windows Office 2003

CODE
Function General_Merge_Word(

DoCmd.SetWarnings Fals
DoCmd.OpenQuery "Preferred Address Firm", acNormal, acEdit
DoCmd.Close acQuery, "Preferred Address Firm
DoCmd.OpenQuery "Preferred Address Home", acNormal, acEdi
DoCmd.Close acQuery, "Preferred Address Home
Call Shell("WinWord " & Forms![General Merge]![DocLoc],vbMaximizedFocus)
DoCmd.SetWarnings Tru

End Functio

Additionally, with word 2000 mail merge you were able to join different tables to create a mail merge but Office 2003 doesn't appear to allow you to join multiple tables.

Appreciate any assistance you can provide

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

I believe that this is probably more of an Access problem than a Word
problem. At lease your code is being executed from Access not from Word.
The code also does not really tell us what is going on. I assume that the
queries must be a make table query and an append query. Also in this
instance Shell appears to be a custom function the definition of which is
not provided.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[JulieD]

Hi Bill

the way i would approach it in Access is to
1) create a table with the output fields of your queries
2) change the first query to an append query and then append the output to
the table created in step1
3) change the second query to an append query and then append the output to
the table created in step 1 also
4) use this table as the basis for your mail merge
5) include code to delete the contents of the table - either after your mail
merge or before step 2

these queries should run reasonably fast and then you have only to open a
mail merge template already created in word that has your new table as its
data source.

Alternatively, you can create an sub-query within a query so that you are
only outputting one lot of information in a query and use this as your
source, but personally i like the first method. If however, you would like
to know how to do this second method .. .post in
microsoft.public.access.queries and someone over there will be able to
assist.

Cheers
JulieD

I recently upgraded from Windows NT4 to Server 2003 with Windows XP

Professional Workstations. I use a Microsoft Access Database for member
records and from that database we were able to successfully perform a mail
merge using Office Professional 2000 with the following code. However we are
unable to do the same with Windows Office 2003.

CODE:
Function General_Merge_Word()

DoCmd.SetWarnings False
DoCmd.OpenQuery "Preferred Address Firm", acNormal, acEdit
DoCmd.Close acQuery, "Preferred Address Firm"
DoCmd.OpenQuery "Preferred Address Home", acNormal, acEdit
DoCmd.Close acQuery, "Preferred Address Home"
Call Shell("WinWord " & Forms![General Merge]![DocLoc],vbMaximizedFocus)
DoCmd.SetWarnings True

End Function

Additionally, with word 2000 mail merge you were able to join different

tables to create a mail merge but Office 2003 doesn't appear to allow you to
join multiple tables.