Save Word 2010 mail merge selection?

Hi,
I have just tried my first mail merge in Word 2010 and have been very frustrated by one thing that I am sure ought to be possible but I haven't sussed. I created a letter to send to around 60 people in an Access database of around 200. All was well as I picked up the query from the DB, added my fields, selected the people I wanted to mail and created the letters. However, I now wanted to create envelopes to send them in. I couldn't find any way of saving the selection criteria for re-use with the envelope document. I had to go through selecting the same people all over again.  I know I could have done this with a selection query in Access but it is so much easier to simply tick the check-boxes in Word mail merge. Is there any way that I have missed to save the letter selection for the envelopes?
Cheers,
Joan
JoanEdingtonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
There isn't any built-in way of copying the selection for later use. I'm not even sure that it is exposed to VBA, so it can't be easily coded.

It is best to regard any reselection in Mail Merge run time as a Q & D convenience, so that if you want to use the selection twice, it is better done in the datasource before it is presented to Word.
0
JoanEdingtonAuthor Commented:
Thanks for that Graham. It seems to have changed a bit since the earlier versions of Word. I was able to create a document from any source and, the next time I opened the source, the selection had been retained. I always had to clear the selection and start again if I wanted a different set of data. That's progress, I suppose. I'll have to rethink my Access query for the future.
Many thanks again for the confirmation.
0
GrahamSkanRetiredCommented:
I'm sorry. I think I misunderstood what you were trying to do.

You should be able to change the merge type to Envelopes... and run the merge again. Unfortunately you will have to insert the merge fields on to the envelope document, but if you have a long list of recipients to change, it may be easier. If the same selection is needed for several runs, you could save the main document before hand as letter type and then separately as envelope type afterwards.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JoanEdingtonAuthor Commented:
Graham, you're a star.  When I went to do my envelopes I started a new document, which wanted a new selection. I didn't think of changing the document type to envelope and saving it while the selection was in place.  It works perfectly. I can't have described my question very well.
Many thanks again.
0
GrahamSkanRetiredCommented:
Thank you Joan.

Your question was OK, but I was a bit tired by eight in the evening, so got hold of the wrong end of the stick. Not your fault.

I am impressed with your efforts to get things just right, especially in reopening the question in order to assign my better, but late, comment as the true answer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.