Hi everybody!
I want to create a macro for mail merge that will allow me to open the
databace and peek the people I wan't to mail to, and only then - continue to
execute the mailed letters.
I've tried to record a macro by doing it step by step in word itself but
this macro saves the people I chose and does not allow me to change my
selection the next time I run this macro...

I hope someone will be able to help me do that...

Re: mailmerge macro by Doug

Doug
Mon Jan 21 02:37:46 PST 2008

You do not need a macro to do that. From the View menu, select Toolbars and
then check the Mail Merge toolbar item. It has a button on it that will
allow you to view the recipients of your mail merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"iris" <iris@discussions.microsoft.com> wrote in message
news:5CF77CC0-52B4-4BAD-83FE-3DEACBEC9148@microsoft.com...
> Hi everybody!
> I want to create a macro for mail merge that will allow me to open the
> databace and peek the people I wan't to mail to, and only then - continue
> to
> execute the mailed letters.
> I've tried to record a macro by doing it step by step in word itself but
> this macro saves the people I chose and does not allow me to change my
> selection the next time I run this macro...
>
> I hope someone will be able to help me do that...



Re: mailmerge macro by iris

iris
Tue Jan 22 16:15:20 PST 2008

Hello Doug!

Thank you for your reply!

I know I can do this through the rulers of word... but since I am making a
macro that creates both mailmerge according to specific cells in access db I
want to enable this feacher also in this userform so people that are not so
"great" with computers or word it self will find it easy to merge mail.

I also know that there is a buildin macro in word that opens the data
recipients: MailMergeRecipients.... but I don't know how to open it in my
userform...

I will be very grateful for any help in doing that....

Thank you

Iris

"Doug Robbins - Word MVP" wrote:

> You do not need a macro to do that. From the View menu, select Toolbars and
> then check the Mail Merge toolbar item. It has a button on it that will
> allow you to view the recipients of your mail merge.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "iris" <iris@discussions.microsoft.com> wrote in message
> news:5CF77CC0-52B4-4BAD-83FE-3DEACBEC9148@microsoft.com...
> > Hi everybody!
> > I want to create a macro for mail merge that will allow me to open the
> > databace and peek the people I wan't to mail to, and only then - continue
> > to
> > execute the mailed letters.
> > I've tried to record a macro by doing it step by step in word itself but
> > this macro saves the people I chose and does not allow me to change my
> > selection the next time I run this macro...
> >
> > I hope someone will be able to help me do that...
>
>
>