Access -> Word (VBA)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Useko Netsumi - 29 Mar 2004 16:34 GMT

I have 4 cols of data in Access and would like to put them in a Word table,
how would I transfer the info from the Access to the Word Table
programmatically(using VBA)?

Note: COL 4 of the Access db contains the location of the jpg image
corresponding to that record.

Thanks and much appreciated.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 29 Mar 2004 22:59 GMT

Hi Useko,

The simplest way to do this would be with a Catalog (or in Word 2002/2003) a
Directory type mailmerge in which you set up a 4 column, 1 row table with a
mergefield for each of the fields in the cells of that table, and nothing in
the mailmerge main document after the table other than the single pargraph
mark ? that you cannot delete anyway. When that merge is execute to a new
document, that document will contain a table with one row of the table for
each record in the data source. To get the images to appear in the fourth
column, see the "Graphics from a database" item under the "Special merges"
section of fellow MVP Cindy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I have 4 cols of data in Access and would like to put them in a Word table,
> how would I transfer the info from the Access to the Word Table
[quoted text clipped - 4 lines]
>
> Thanks and much appreciated.

Reply to this Message