divide mail merged file into separate files.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vivian - 09 Oct 2003 19:34 GMT

Hi,

How do you break up a mail merge document into separate
files? For example, I created a mail merge document which
contains letters to be sent to different recepients. I
would like to separate the letters into individual ones
and save the soft copy to each recepient's file folder.

Any help is appreciated.

Thanks!

Vivian

Reply to this Message

Cindy M -WordMVP- - 11 Oct 2003 11:52 GMT

Hi Vivian,

> How do you break up a mail merge document into separate
> files? For example, I created a mail merge document which
> contains letters to be sent to different recepients. I
> would like to separate the letters into individual ones
> and save the soft copy to each recepient's file folder.

You'll find one possible approach on my website. Another is
on the mvps.org/word site, I think.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message

Vivian - 13 Oct 2003 23:36 GMT

Hi Cindy,

Thanks for your response. I think the Mail Merge Events
is what I am looking for. I had tried running the sample
you posted (employee table), but when the script is
compiled, I received an error indicated
SubType:=wdMergeSubTypeOther Variable not defined. I had
tried changing it to SubType:=wdMergeSubTypeWord2000 but
it didn't make any difference. Please help!

The sample files were found at this link:
http://homepage.swissonline.ch/cindymeister/MergFram.htm

thanks, Vivian.

>-----Original Message-----
>Hi Vivian,
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 14 Oct 2003 15:48 GMT

Hi Vivian,

Which version of Word are you working with?

The mail merge events were introduced in Word 2002, and
won't work in any earlier version. ditto the SubType
argument you mention.

> Thanks for your response. I think the Mail Merge Events
> is what I am looking for. I had tried running the sample
[quoted text clipped - 3 lines]
> tried changing it to SubType:=wdMergeSubTypeWord2000 but
> it didn't make any difference. Please help!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

Vivian - 15 Oct 2003 18:33 GMT

Hi Cindy,

That explains it. I am running Word 2000 on Windows 2000.
I believe Word2002 is for XP? or will it also work for
Win2000?

I've found and tested another script of yours that did
exactly what I wanted to do, which is to break up the mail
merge document. Thank you for that.

On the same mail merge master document, how do I merge
fields using barcode 128 fonts?

Thanks for your help.

Vivian.

>-----Original Message-----
>Hi Vivian,
[quoted text clipped - 24 lines]
>
>.

Reply to this Message

Peter Jamieson - 24 Oct 2003 20:39 GMT

> I believe Word2002 is for XP? or will it also work for
> Win2000?

Word 2002 should be OK on Win 2000. There's always a possibility that you
will find some differences in behaviour - you just have to try it.

> On the same mail merge master document, how do I merge
> fields using barcode 128 fonts?

As long as your mail merge data source contains the exact string that needs
to be displayed, use the \*Charformat switch within the Word field and
format the "M" of "MERGEFIELD" using the barcode font.
--
Peter Jamieson
MS Word MVP

> Hi Cindy,
>
[quoted text clipped - 47 lines]
> >
> >.

Reply to this Message