3 on 1 page member card template

[Alpha]

I need to create a template in Word to print membership cards which fits 3 cards on one page (pre-printed paper) so each each card takes up about 3.75 inches and there will be 3 on a page. I have VBA codes with this template that would call a SQL stored procedure to return all the records (each record is one member) that needs to be printed. A main program will call my code and pass me the number of membership cards needs to be printed.

Are there any template out there similar that I can take a look at? I thought about using inserting a table per page but don't know how many pages/tables to create until my module is called. Or, would this be better done in Crystal Report

Thanks,
Alpha

 

[Doug Robbins - Word MVP]

In your template, I would just insert a one cell table with that cell having
fixed dimensions and then have you VBA code add another row to the table for
each record, inserting the data for each as it goes

You may however be able to use a label type mailmerge to do what you want.
An Avery L7905 layout will give you 3 cards per sheet, each measuring 93mm x
210mm - there is probably an imperial size equivalent, or you can create
your own custom label.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I need to create a template in Word to print membership cards which fits 3

cards on one page (pre-printed paper) so each each card takes up about 3.75
inches and there will be 3 on a page. I have VBA codes with this template
that would call a SQL stored procedure to return all the records (each
record is one member) that needs to be printed. A main program will call my
code and pass me the number of membership cards needs to be printed.

Are there any template out there similar that I can take a look at? I

thought about using inserting a table per page but don't know how many
pages/tables to create until my module is called. Or, would this be better
done in Crystal Report?