Having a problem mail-merging from a query.

[diasflac]

I have a very large query which combines fields from several tables. For some reason Access seems to not like this many fields in a query, all are required. Once too many are added some of the fields become renamed to - "tablename"."field Name". This in itself isn't a major issue as users cannot see the query.

When I set up the mailmerge fields, it adds the merge field as it's listed in the query; however, when I come to actually merge the document I get an error that these merge fields cannot be found and have to select correct fields which are now listed under their original field names.

I have tried setting up the query again but the same problem happens just with different fields. I tried re-merging and that hasn't worked either.

There seems to be some problem with setting up via the query as the fields don't really change name but when you set up the merge fields you have to use the current name.

Any help would be appreciated.

 

[pr2-eugin]

How about renaming all your field names in the Query?

SELECT tableName.FirstName [COLOR=Red][B]AS nameField[/B][/COLOR], tableName.addressline1 [COLOR=Red][B]AS propertyAddress[/B][/COLOR]
FROM tableName