Using SQL in Word MailMerge

D

Dale

Hello all


Can anyone suggest how I can implement a way to programatically choose
certain records in a mail merge? I've been getting some results through
trial and error but if someone post some code to help me better understand
the process that would be great.

From my data, I'd like to choose the first two records and the last two
records and every X records to come up with about 20 sample records no
matter the size of the data file.

Anyone out there trying to do something similar?

Regards
Dale
 
M

Margaret Bartley

I suspect you would be better off to create a query in your data source that
does that logic, and then run that query, rather than select the whole set
of data and try to have the MailMerge interface do that logic. That's what
you're paying MS to do, for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hints on managing MailMerge using VBA 1
More Mailmerge Problems 1
Field Calculation Error in Mailmerge 1
Word 2007 mailmerge from Access 2007 3
SOLVED: Skipped records in Word Mailmerge from Excel data source 0
Access 2007 mailmerge to Word 2007 code required 2
Word maximum no of fields in MailMerge 1
Mail Merge office 2003 from SQL 2000 Database 0

Top