Mail Merge - Guidance on how to mark records as merged
Posted on 2011-09-06
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.