Printing invoice in Word 2003 from link on web page

[elle0612]

Hi

I am planning to create a dynamic website using ASP/Access.

I thought of an idea to include a hyperlink from the website to open a Word
2003 document complete with VBA code, which (hopefully) would pick up values
from the Access database and generate all the invoices that currently need to
be paid. The invoices can then be printed straight off.

I guess I would need some sort of mail merge and some code writen in VBA to
connect the Word document to the Access database, and an SQL query, something
like "Select * FROM Customers WHERE invoicePaid = null"

Can anyone point me in the direction of some tutorials/information on this
type of thing - ie generating documents in Word 2003 with values taken from
an Access database.

Thanks

 

[Doug Robbins - Word MVP]

I would suggest that your invoices be created as reports in Access. Mail
merge in Word is definitely not the best thing to be trying to use for this.

To learn more about what would be involved, see the "Group Multiple items
for a single condition" item on fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP