Thread: [Solved] Can't merge mail from Excel
View Single Post
 
Old 04-06-2014, 02:51 AM
Mahmed1 Mahmed1 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Apr 2014
Posts: 17
Mahmed1 is on a distinguished road
Default

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
Reply With Quote