Different Records Different Files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ongailing - 09 Nov 2006 14:07 GMT

i've created the word document with different fields and the EXCEL fil
is also ready for mail merge.
But when I merge, all records are on 1 file. How can I do it so tha
each record is separately as 1 file? The purpose is that each file wil
be sent as an attachment to different email receipt.

HELP PLS!

Thanks

--
ongailin

Posted from - http://www.officehelp.i

Reply to this Message

Doug Robbins - Word MVP - 09 Nov 2006 21:44 GMT

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

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

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.

Signature

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

> i've created the word document with different fields and the EXCEL file
> is also ready for mail merge.
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

ongailing - 10 Nov 2006 01:11 GMT

Hi Thanks for the website. But after installing the ADD IN.
I still cant seem to get the prompt about getting individual letters.
I'm not too sure of this step
"Extract the MMtoDocsRevnn.DOT template (where nn is the lates
revision number) to the Word startup folder - its location defined i
Word at Tools > Options > File Locations > Startup.

--
ongailin

Posted from - http://www.officehelp.i

Reply to this Message

Doug Robbins - Word MVP - 10 Nov 2006 04:40 GMT

What version of Word are you using?

The Word Startup folder is usually located in:

C:\Documents and Settings\[User Name]\Application
Data\Microsoft\Word\Startup

Signature

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

> Hi Thanks for the website. But after installing the ADD IN.
> I still cant seem to get the prompt about getting individual letters.
> I'm not too sure of this step
> "Extract the MMtoDocsRevnn.DOT template (where nn is the latest
> revision number) to the Word startup folder - its location defined in
> Word at Tools > Options > File Locations > Startup. "

Reply to this Message

Graham Mayor - 10 Nov 2006 05:44 GMT

It doesn't really matter where the template is stored, provided that it is
listed and checked in tools > templates and addins. Having it in the correct
startup folder will ensure this each time Word is started - saved anywhere
else and you will have to check it before using it.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

.

Reply to this Message

ongailing - 14 Nov 2006 10:21 GMT

I was ABOUT to complete but I met this error
RUNTIME ERROR 91, OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET

:( HO

--
ongailin

Posted from - http://www.officehelp.i

Reply to this Message

Doug Robbins - Word MVP - 16 Nov 2006 17:15 GMT

And which line of code is highlighted if you click on Debug?

Signature

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

> I was ABOUT to complete but I met this error
> RUNTIME ERROR 91, OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET
> :( HOW

Reply to this Message