How to merge records into word doc, depending on document name

[Shimon J]

Hi All,

I would like to merge a set of records forom my database. I would like for
word to merge only the records the the field "FILENAME" in access = the
current document name. Thanks for any help.

Sincerely,
Shimon J.

 

[Graham Mayor]

Depending on what you are doing with the merge and what exactly the filename
field contains a SKIPIF field in the merge document may suffice

{ SkipIf { Mergefield Filename } <> { Filename } }

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Shimon J]

Hi Graham,
Thanks for the quick response. I tries the skipif, but the dialog box lets
me enter text, I would like to check each document by its name
automatically. If I am opening a file called ElectricProducts.doc, I would
like it to merge all records that have the value "ElectricProducts" (or I
can convert the value to "ElectricProducts.doc) in the Filename field. I
imagine that I would have to do it programmatically, but maybe not.
Thanks allot,
Shimon

 

[Graham Mayor]

I don't understand your point about 'dialog'. There is no dialog involved.
Enter the fields directly in the merge document using CTRL+F9 for each pair
of brackets {}.

If you only have ElectricProducts in your filename field then you don't need
to change that, use
{ SKIPIF "{ Mergefield Filename }.doc" <> { Filename } } instead.

It will not work in a label merge, but form letters and directory merges
should be fine.


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Shimon J]

Hi Graham,
I was using the Merge Toolbar, and that was the choice I was getting. I did
it the way you wrote and I got it working somewhat, but I need help in
tweaking it.
I need to describe certain items. These items are then imported to a
typesetting program for print. The problem is that allot of information
(price , size, year of manufacture) should be stored in the database and if
they are changed or corrected, it should be easy to update it in the
document. The problem with the regular merge is that it creates a new
document with all the info in it, but it won't update when I change the info
in the DB.
I need a way to incorporate some fields that get updated and some paragraphs
that are written, maintained and changed in word.
If you have any suggestions, I would greatly appreciate it.

Shimon

 

[Graham Mayor]

From your description, this is straightforward mail merge. Maintain a merge
document containing the fields that reflect your data source and merge to a
new document. The merged document should reflect the changed data in your
data source. If you change the data - re-run the merge and create a new
document.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Shimon J]

Thanks allot Graham,
That's what I did and it works fine. I'm not using the SKIPIF
filenme=filename, as that would not enable me to enter specific data for
specific items. Instead I'm experimenting with "if Autonumber= #1111#",
where I put in the digits and the info that I want to keep in word document
and the merged file has all the info.
Thanks allot. I'll probably have some more questions for you in the future.
As always, you have been very helpful.
May you have all the best for you and yours.
Shimon