Help needed saving access 2003 reports as individual files

[robert]

I have an access 2003 report that is actually a 1 page invoice for
about 90 individual memberships. I want to merge that with world
merge (if any of you are familiar w/ that program) and email a
dedicated notice to each member. In order to do that i have to set up
my access report to export/save each page as an individual record. I
want to save each record as: invoice_memberID ... where memberID is
the primary key. The closest I've come to this is creating an html
export that saves as some name1, some name2, where 1 and 2 are the
page numbers but that doesnt cut it, microsoft help only says these
two things about it:

By default, Access automatically creates a separate HTML file for
each page using the file name and a suffix; for example,
Products.html, ProductsPage1.html, ProductsPage2.html, and so on. For
more information on exporting reports to HTML, see Access Help.


AND

In this case, you can create a Microsoft Visual Basic® for
Applications (VBA) program that enumerates through the record set and
uses the PRINT statement to output each record as a separate HTML
file.


this info can be found here: http://office.microsoft.com/en-us/access/HA010345961033.aspx

Can anyone help with this? Thanks in advance

 

[Pete D.]

I think your working backwards. Use access as the datasource and do the
mail merge in Word. I think you'll find it easier. This is kind of
standard fair for word, suggest you talk it up in a word news group, you may
find it much easier. You can do it in Access but if I was going to do this
I'd make a report look like the word document and spool each report to my
email program directly.

I have an access 2003 report that is actually a 1 page invoice for
about 90 individual memberships. I want to merge that with world
merge (if any of you are familiar w/ that program) and email a
dedicated notice to each member. In order to do that i have to set up
my access report to export/save each page as an individual record. I
want to save each record as: invoice_memberID ... where memberID is
the primary key. The closest I've come to this is creating an html
export that saves as some name1, some name2, where 1 and 2 are the
page numbers but that doesnt cut it, microsoft help only says these
two things about it:

By default, Access automatically creates a separate HTML file for
each page using the file name and a suffix; for example,
Products.html, ProductsPage1.html, ProductsPage2.html, and so on. For
more information on exporting reports to HTML, see Access Help.


AND

In this case, you can create a Microsoft Visual Basic® for
Applications (VBA) program that enumerates through the record set and
uses the PRINT statement to output each record as a separate HTML
file.


this info can be found here:
http://office.microsoft.com/en-us/access/HA010345961033.aspx

Can anyone help with this? Thanks in advance