Merge Problem

  • Thread starter Thread starter CompuGenie
  • Start date Start date
C

CompuGenie

I posted an example of what I've done so far on a web page:
http://compugenie.net/mergeproblem.html

The problem: Using Access 2000 and Word 2000, I want to be able to
import records from an Access database into a Word document that will
display employee information one after the other in a horizontal
format to produce a printed employee directory.

The top table should be at the top of each page.

The employee information needs to line up underneath the headings in
the top table.

When I merge the database into the document it looks great but there
is only one record on the first page and each subsequent record starts
a new page with the top table and only one record.

BTW, the company I work for has always had a printed directory in this
format, but they typed it out every year in Word before sending it to
the publisher. The task this year is to use a constantly updated
database for the information so they don't have to type all of the
information. In other words, I'm stuck with this format.

Any help will be GREATLY appreciated. I can be reached on the
newsgroup or at CompuGenieATyahoo.com (replace AT with @).

TIA!
 
You cannot use Word MailMerge for this one as MailMerge will create ONE
merged document for each Record / Row in the Merge DataSource.

You need to use VBA code to create a Recordset of Employee Details, use
Automation (Word as server and Access as client) to open the Word Doc (or a
new Doc base on a Template), traverse the Recordset and add data from each
Record as the cell contents of a new row in the second Word Table.

If you are not familiar with VBA, Access Object Model and Word Object Model,
it may take quite a bit of effort to get this done. Alternatively, you may
be able to get professional help from your local area.
 
Thank you very much!

I am not familiar at all with VBA, Access Object Model and Word Object
Model. I'll let the powers-that-be know that I won't be able to help
them with this project.
 
As Van said, you would need to write some code to do this in Word.

I took a look at you sample.

Unless there's something I'm missing, this is exactly what a standard Access report will produce.

Why are you trying to use Word for this?

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Excellent point, Sco.

I concentrated on the MailMerge and didn't even think about Access Reports.
 
Inline...

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Van T. Dinh said:
Excellent point, Sco.
Click to expand...

Van, can I log that? I'm low on "excellent points" this year. :-)
I concentrated on the MailMerge and didn't even think about Access Reports.
Click to expand...

Isn't that what us Access guys are supposed to do? ;-)
 
Back
Top