Results 1 to 2 of 2
Thread: Mail Merge Error (2003)
2005-01-28, 14:05 #1
- Join Date
- Oct 2002
- Leamington Spa, Warwickshire, England
- Thanked 0 Times in 0 Posts
Mail Merge Error (2003)
I have several data sources set up in Excel. The appropriate fields have been inserted into a word document. This datasource was then queried on. However when I go and try to do another merge when I open the main document I get a
"opening thie document will run the following SQL
select * from sheet1 where field = x
data will be placed in your document do you want to continue?"
At home (xp home) if I say no. i have to go find the data source and insert insert all the merge fields again
If I say yes it will insert the names and addresses
At work (xp professional) if i say no, i have to go find the data source and insert insert all the merge fields again
If I say yes it seems to be Ok and will let me performanother query.
Am I doing something stupid? i have been using Mail merge for years and know what I am doing. Someone said I was moving the datasource but i'm not. Ican't understand why suddenly i can't query. I have tried making sure that in select recipients no queries are appearing before I close the main document but it still won't work.
As I use this data source on a daily basis it would be quite usful t see if others have had this happen.
2005-01-30, 22:11 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Mail Merge Error (2003)
See <A target="_blank" HREF="http://support.microsoft.com/?kbid=825765">You receive the