Thank you
I will give that a go
Just out of curiosity, what was causing that error for freezing up and what changes made to the code should prevent that?
and now when ever i open up the Word document, i get this message "Opening the document will run the SQL command, SELECT * FROM ADDRESS, do you want to continue. I dont have sheet called Address. Just a named range for the data called address which i can delete.
Should this message keep popping up?
Ps have I set up the word document correctly and say I wanted an ENVELOPE OR LABEL structure, would you advise to set up another 2 documents with the correct layout (so 3 template documents) if you like
Letter
Envelope
Label
And then in the code have a msgbox to say what format I would like and then based on that, change the correct document to open and change format to based on which 1 I selected. Is that the best way to go about it?
Again many many thanks
Last edited by macropod; 04-06-2014 at 02:53 AM.
Reason: Deleted quote of entire post replied to
|