R
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
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