Problem mailmerging query data into MS Word

  • Thread starter Thread starter Ross Gwyther
  • Start date Start date
R

Ross Gwyther

I have Windows XP as my operating system, and Office 2000
installed.

When I try to mailmerge into a word document using an
access QUERY as the datasource, none of the records in the
query show up in the "edit data source records" (even tho
the query has records which are usable from access itself).

Using an access TABLE does not show this problem.

Can I please find some assistance on this problem?

Thak You.

Ross Gwyther
 
I am having the exact problem. Did you get it solved

I am using access 2002 with MS word 2002 to do a mail merge in word from 2 tables in access using vb

The Debtor entry and Client entry forms and tables work as expected
I created a query in Access that pulls the debtor and client information needed for the third letter as a test and first attempt. I created 1 calculated field in the query that totals the different debt fields (5 fields), (principle + collection charges etc.
I am trying to create the merge letter in Word but it does not see the query. I remove the calculated field and the query appears to word so I can insert the fields manually

It appears the calculated field contains ,'s that are throwing off Word. I think??

sql view from access is a Select query that works in access but isn’t available from Microsoft wordâ€

SELECT tblClients.ContractID, tblClients.CompanyName AS tblClients_CompanyName, tblClients.Address AS tblClients_Address, tblClients.City AS tblClients_City, tblClients.StateOrProvince AS tblClients_StateOrProvince, tblClients.PostalCode AS tblClients_PostalCode, tblDebtors.FirstName, tblDebtors.LastName, tblDebtors.Address AS tblDebtors_Address, tblDebtors.City AS tblDebtors_City, tblDebtors.StateOrProvince AS tblDebtors_StateOrProvince, tblDebtors.PostalCode AS tblDebtors_PostalCode, tblDebtors.CompanyName AS tblDebtors_CompanyName, tblDebtors.PrincipleAmount, tblDebtors.DateDebtIncur, tblDebtors.StartFrmFee, tblDebtors.NSFFees, tblDebtors.AddedInterest, tblDebtors.Collectchgs, Nz([PrincipleAmount],0)+Nz([StartfrmFee],0)+Nz([NSFFees],0)+Nz([AddedInterest],0)+Nz([Collectchgs],0) AS TotalDue, tblDebtors.LtrAuditSen
FROM tblClients INNER JOIN tblDebtors ON tblClients.CliContactID = tblDebtors.ContractID
 
Back
Top