Splitting a merged doc into separate docs and emailing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanya - 09 Dec 2003 03:53 GMT

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.

Reply to this Message

Tanya - 09 Dec 2003 05:28 GMT

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

>-----Original Message-----
>I have merged a excel database into a word document to
[quoted text clipped - 5 lines]
>Hope this makes sense, and thanks in advance.
>.

Reply to this Message

Graham Mayor - 09 Dec 2003 08:46 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> 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
[quoted text clipped - 11 lines]
>> Hope this makes sense, and thanks in advance.
>> .

Reply to this Message