How to edit data source?

[skp]

I am trying to add a merge field to the data source but dont know how to actually do it. We have letters that are sent from Word and the data is merged from Access however there is an additional field that needs to be added. When I go through the merge process in word all the other fields merge perfect except one "Add City" field and I get this error:

"The merge field exists in the main document but does not exist in the data source. Remove the field from the main document or replace it with a valid field from the data source."

When I select the drop down menu of valid fields from the data source "Add City" is not listed. So how am I able to add the "Add City" field to the data source so it will be valid and able to merge?

 

[vbaInet]

Wouldn't that be Add_City?

By the way, does that field actually exist in the data source?

 

[skp]

The field is on a form with all the other merged information (name, address, phone number etc) which all of those fields merge just fine but the Add_City field when I merge says it does not exist and is an invalid merge field in the data source.

I took this database over from someone else who had created it and I dont have much experience with data source and merging. It seems like it would be simple to make the Add_City field valid and add it to the data source but I honestly have no clue how.

So basically, how do I see if the field actually exists in the data source? And if it doesn't, how do I add it?

 

[vbaInet]

So basically, how do I see if the field actually exists in the data source? And if it doesn't, how do I add it?

By opening up the data source and checking to see if it has the field.

 

[skp]

Like I said I have no experience with data sources I dont know where the data source is and where to find the fields that are in it.

 

[vbaInet]

In that case you want to ask this question in the appropriate section of the forum. This is a Word mail merge question.

Or perform a Google search on how to find the data source of a word document. Once you've found it open up the Access db and have a look at where it's pointing.