Splitting a merged doc into separate docs and emailing

[Tanya]

I have merged a excel database into a word document to
create 45 letters, is there a quick way or a vba to split
each page and save into 45 different documents and then
email OR is there a way to send each page of the 45 pages
as an attachment to 45 different email addresses.

Hope this makes sense, and thanks in advance.

 

[Tanya]

I've found a fantastic link to give a vba to do this, so
good luck to everyone. Now I've just got to find the
email section to my question.

http://www.gmayor.com/individual_merge_letters.htm

 

[Graham Mayor]

I was just about to post that link but you found it
It may be simpler simply to merge to e-mail rather than to a new document,
though Word's merge to e-mail is relatively weak.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>