Start mail merge from Excel

By maryt66 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Merges are usually started from within Word...

by ThumbsUp2 In reply to Start mail merge from Exc ...

... 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.

Collapse -

Good answer Thumbsup2

by dazeboy79 In reply to Merges are usually starte ...

And this link should help explain the processes and capabilities of mail merging...

Related Discussions

Related Forums