Forum Home
Press F1
Thread ID: 9758	2001-06-13 20:02:00	MSWord Mail Merge Macro	Guest (0)	Press F1

Post ID	Timestamp	Content	User
14105	2001-06-13 20:02:00	In MSWord 97,I have developed a Mail Merge using a comma delimited file as the data source. It uses an Excel Field Names file. I am working on developing a macro which when opened automatically merges to the printer, lets the user select the printer desired, prints the merged letters and closes the file. First problem - is that when the file opens, a dialogue box appears to define Sheet1 and the range for the Field Names file. I can't find the name of this dialogue box or the code I need to have the macro automatically put in 'Sheet1' and the range 'a1:ao1' into the dialogue box. Second problem, but easier to find. I don't know the code to use to allow the user to select the printer. Any help would be appreciated. Thanks, Amy Conklin	Guest (0)
14106	2001-06-15 23:59:00	Are two applications becoming confused. Do you need the Excel Macro for Sheet One etc. Just a thought.	Guest (0)
1