Mail Merge "Skip Record If" myMailMergeField != current Windows username?

i automating mail merge putting mail merge data sql database table.  1 record (document) produced in mail merge.  table contains 1 record @ time.

i write out multiple records database table, including column windows username, , in mail merge, use current windows username select record use mailmerge.  use "skip record if" usernamefield != current windows username.

does make sense?  possible?  if has done vb script, can tell me how it?

rather using mail merge intended creating multiple letters data source, might want consider using method in the article "access database , insert word document data find there” at:

http://www.word.mvps.org/faqs/interdev/getdatafromdb.htm

to see how name of current user, see article "how username of current user” at:

http://www.word.mvps.org/faqs/macrosvba/getcurusername.htm

another method may want consider use routine developed fellow mvp albert kallal can obtained from:

http://www.kallal.ca/wordmerge/page2.html

---

doug robbins - word mvp dkr[atsymbol]mvps[dot]org

Microsoft Office  >  Word IT Pro Discussions