Using Mail Merge in Word with SQL database

Question

I am using the latest version of Word to create a mail merge to print ID badges.

I understand how to set up a mail merge in Word to connect to an SQL database and pull the information from the database, but what happens when the SQL database is updated, say with a new record? Is the merge a "one time" event, and in order to update the fields with a new record I'll have to re-merge the file? Or does Word perform an update when Word is restarted and the document re-opened?

I'd like to use Word to print ID badges using a merge document, but our employee database will constantly be updated, and I want a straightforward way to ensure Word pulls the latest information from the database, at least when opening the document.

Answer 1

Hi Pablo,

A completed mailmerge is a one-time-event. The link between the document and the data is lost. The simplest thing to do is a new merge with your primary merge document and your data.

I hope this information helps. Please let me know if you have any more questions or require further help.

Regards