Log in

View Full Version : Macro to unprotect a form to get an address & copy into an envelope & reprotect form



Chukesgirl
08-04-2008, 05:15 PM
I have a template form that is protected. In the form there is a text box control (which is in a table because there can be more than one address) for the user to insert an address. I need the user to be able to create an envelope from that address text box. I would like a macro that will do the folllowing things after the user has put his cursor on the address:
1. unprotect the document
2. select the cell with the address in it and copy it
3. create the envelope
4. add the envelope to the document
5. re-protect the document
6. As a bonus, it would be nice if it would print the whole thing, but not necessary.:help

Chukesgirl
08-04-2008, 09:03 PM
Iam not sure how this solution willl work for me because there is more than one place that the address can be taken from, actually, there are 3 address text boxes but the user only adds information to the one that applies to the type of mailing they are doing, so it seems like I would have to put in a lot of If statements for the 3 different formfield properties, depending on which type of mailing the user does? I do like the idea of putting in an envelope page---just not sure how to code this. Thanks.