|
Answer» i am trying to create a letter generator in excel / word like this :
http://www.youtube.com/watch?v=-npLOc6UUbQ
i have an excel data base with customer infomation and a word document that i fill the info in, at the momeny manually , i wold like to create a button on the excel doc that automatically generates a word document, or even a PDF,
PLEASE HELP!ACCESS Database with VB would be better than a flat excel spreadsheet database. As far as making PDF's, this can be done by PASSING a print INSTRUCTION with default printer of doPDF which is free. As far as populating a MS Word document, I haven't done that yet automatically without other macro software, however the information can populate a FILE that is saved as a *.doc etc and formatting tailored to work in the VB file write.
*Unable to view the video you linked from work, but just suggesting what I would do if I had to have a database that generated PDF's and letters/documents.
|
