ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   printing forms (https://www.excelbanter.com/excel-programming/371743-printing-forms.html)

milos

printing forms
 
Hi, i have this table in one sheet
Name Surname Adress Tel.No. E-mail Gender
Paul Gaultier Baker st 9995 M
John Smith Rose st. 5556
F

And in another sheet I have couple of forms (application forms,
questionnaires)
Applc. form. No.1
Name: Surname:
Adress:
E-mail:
Gender:

My wish is, to have buttons (or functions) next to each name, that will
print each form with data of this person put in right boxes of the forms.
Name Surname Adress Tel.No. E-mail Gender Print Form
Paul Gaultier Baker st 9995
M Print Form No.1
John Smith Rose st. 5556
F Print Form No.1

I can have the forms in word or excel format. Mailmerge doesn't solve my
problem, because that I'll need to make many steps (open file, use filter,
print it, ...).
All I need is one button for each form next to each case.
Is it possible?



All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com