Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Mail merge w/grouping records and dividing results to separate files?

1 view
Skip to first unread message

Heidi M

unread,
Feb 14, 2008, 4:32:42 PM2/14/08
to
I have a report I've currently created in Access because I needed 2
levels of grouping - I have a 16-day event where there are multiple
exhibits each day, so I need to group first by customer, then by
exhibit. The details per exhibit list the dates, number of tickets
ordered per guest, and price per date.

I have published this to Word because I need to be able to save each
person's report as a separate file, so I can continue on towards a
email merge with attachments to send those files to each customer.
The problem is that if I didn't start as a Word mail merge, I can only
find macros that split a general Word document based on a number of
pages with a generic file name. The number of pages will vary from
guest to guest and I need to name the file based on the customer's
account number, so I'm looking for one of two things:

Either A) a way to create this multi-level grouping as a mail merge
directly in Word, so I can run the macro I already have to name the
file based on a field contained in the merge, or B) Another way to
export my report from Access so I can separate the file another way.

Any help will be greatly appreciated! (I am somewhat familiar with VB
but not an experienced programmer).

0 new messages