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).