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...![]()
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks