Software

Ask something
Question Locked

Start mail merge from Excel

0 helpful
3 replies

by maryt66

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have customer data in an Excel spreadsheet. I have a number of different letters as Word templates that I send to my customers. From Excel I would like to choose a letter type and (on the press of a button) have the letter merged with the selected customer details and printed.

Does anybody know if this is possible? I have written the macro to open a new word document based on a template, but how do I merge specific contact information?

Thanks for any help

3 replies

by thumbsup2

... does your template have the data source set? And, your merge will have problems if the data source is already open. It's best to start the merge from within Word, leaving the spreadsheet closed.

This discussion is closed to new replies.