Hello again AWF 
I have a problem i hope someone can help with.
I have an access database that handles our customers, orders, quotes etc. and works quite well. It has become so relied upon in the office that others are now making suggestions they'd like to see on the development. Thats good for me.
The latest one relates to external word documents. At present when we need to do a new quote for a customer, the database is used to add the quote details (ie date, customer name, quote value etc etc). then a "create quote from blank template" button is clicked and word pops up, opens the "quote.dot" template, pastes the address, date, quote number & reference to it using bookmarks & then saved as a word document to the server (ie. 14940 - quote.doc).
This part is OK. The quote.dot template however has a 6.8cm header & 2cm footer area on page 1 and 2.9cm header & 2cm footer for all other pages. This is because the quotes themselves are printed onto pre-printed letterheads for posting.
The problem:
We now need to be able to email the quotes to some customers and at present have to print the quote out on the letterheaded paper then scan it to pdf, save it, then email it. This is ok but invariably the scan is not quite square & quality lacking.
I want to be able to print the (already saved) word document to pdf with a computer generated letterhead. How would i do this ?
I was thinking either to create a report that has the letterhead info & import/merge the text from the quote to it, then email it or using vba, create a button on the quote details form in the database "email attached quote" which opens the word document in read only, inserts the necessary header & footer, then attaches itself (as pdf) to outlook new message....
Not sure which would be best !!!
Any suggestions appreciated.
I have a problem i hope someone can help with.
I have an access database that handles our customers, orders, quotes etc. and works quite well. It has become so relied upon in the office that others are now making suggestions they'd like to see on the development. Thats good for me.
The latest one relates to external word documents. At present when we need to do a new quote for a customer, the database is used to add the quote details (ie date, customer name, quote value etc etc). then a "create quote from blank template" button is clicked and word pops up, opens the "quote.dot" template, pastes the address, date, quote number & reference to it using bookmarks & then saved as a word document to the server (ie. 14940 - quote.doc).
This part is OK. The quote.dot template however has a 6.8cm header & 2cm footer area on page 1 and 2.9cm header & 2cm footer for all other pages. This is because the quotes themselves are printed onto pre-printed letterheads for posting.
The problem:
We now need to be able to email the quotes to some customers and at present have to print the quote out on the letterheaded paper then scan it to pdf, save it, then email it. This is ok but invariably the scan is not quite square & quality lacking.
I want to be able to print the (already saved) word document to pdf with a computer generated letterhead. How would i do this ?
I was thinking either to create a report that has the letterhead info & import/merge the text from the quote to it, then email it or using vba, create a button on the quote details form in the database "email attached quote" which opens the word document in read only, inserts the necessary header & footer, then attaches itself (as pdf) to outlook new message....
Not sure which would be best !!!
Any suggestions appreciated.
