I don't know if i post this correctly, so i will double post in both excel and word forums.
My excel file is in the attachment, and we sell 3 products.
Based on the size, and options, i get different prices for each product.
After i finish with one customer (EG. so only E3:G21 has data), i want that when i press the button "genereaza oferta" (in english is generate offer), the data from that range (e3:g21) is sent to a form... or a word file, with autocompleted standard words, (eg: Hello Mr .... based upon your request for quotation, we send you this offer... etc) so i can save it, mail it,...
The standard text should be automatically there, but i want text boxes or something.... when data for each client is different,...like "name", "contact details",
In the word attachment i will write in black the the text that is always there, and in red new text for each customer so you understand what i want.
If there is a way for doing this only with excel,... it would be great, but if not,it's ok i guess...
Bookmarks