<div>
I don't think there is a built-in function in Word for this. &nbsp;I would go with VB - I have updated database records using VB in Excel and I am sure Word would be quite similar.<br />
<br />
It sounds like you don't want specifics so I won't post any, but if you want more detail let us know.<br />
<br />
Good luck!
</div>


<div>
Okay, so with VBA... how would I go about doing that? &nbsp;(The actual code that does the SQL Update I'm good with)<br />
<br />
Is there a AfterMerge event, or something similar that I could use to trigger the update? I'm just trying to figure out how I would go about doing that?<br />
<br />
Or would I need to create a custom interface that starts the merge and updates the SQL all in one?<br />

</div>


<div>
The recordset is being called via the merge itself... at this point, I haven't created any VBA code.<br />
<br />
So, it's looking like putting in an Update command into the AfterMerge event will work nicely.<br />
<br />
Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Hi all -<br />
<br />
So, here's my situation.<br />
<br />
I have a SQL Server with a bunch of records. I need to create labels for the records. My department is always adding new records, and we're always needing to print more labels.<br />
<br />
I created a Word 2007 mail merge document that creates such labels, and filters on a boolean (bit) field called LabelPrinted. &nbsp;So, all my coworkers need to do is open the Word document, hit merge, and boom, done.<br />
<br />
However, I am stuck at how to then mark the records as LabelPrinted=true<br />
<br />
Can someone point me in the right direction for the most efficient and smoothest way to do this?<br />
<br />
Is there some built in function within Word to do this? Or do I need to resort to VBA code? Or something else?<br />
<br />
If VBA, what logic should I use? I'm experienced with VBA from Excel... I'm sure I can stumble through Word with some guidance.<br />
<br />
I hope that all makes sense. I'm just looking for a starting point as to how I should go about this... I want to figure out the nitty gritty myself.<br />
<br />
Thanks!<br />
<br />

</div>
</div>


Hi all -

So, here's my situation.

I have a SQL Server with a bunch of records. I need to create labels for the records. My department is always adding new records, and we're always needing to print more labels.

I created a Word 2007 mail merge document that creates such labels, and filters on a boolean (bit) field called LabelPrinted.  So, all my coworkers need to do is open the Word document, hit merge, and boom, done.

However, I am stuck at how to then mark the records as LabelPrinted=true

Can someone point me in the right direction for the most efficient and smoothest way to do this?

Is there some built in function within Word to do this? Or do I need to resort to VBA code? Or something else?

If VBA, what logic should I use? I'm experienced with VBA from Excel... I'm sure I can stumble through Word with some guidance.

I hope that all makes sense. I'm just looking for a starting point as to how I should go about this... I want to figure out the nitty gritty myself.

Thanks!



Mail Merge - Guidance on how to mark records as merged

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.