Discussion Locked

Copy text from field in Access to Word

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I am interested in copying a memo field in an
Access table to a Word document.
Thank you.

5 replies

by oz_media

I thin you can Export the record from the file menu into a CSV file or RTF. It will ask you which fields to map, where you can specify the Memo field.

The CSV file can be opened in Excel or an RTF can be opened in Word.

I don't know if these are the file types you will choose, you do have options, but the Export in Access is the easiest way.

by hurdk

Thank you.
I am interested in the code. It is something like

Dim objApp As Object
Set objApp = CreateObject("Word.Application")
objApp.Visible = True

I need to establish a path to the Word document

Thank you.

by hurdk

Thank you.
I am interested in the code. It is something like

Dim objApp As Object
Set objApp = CreateObject("Word.Application")
objApp.Visible = True

I need to establish a path to the Word document

Thank you.

by d-ced

The easiest way to get the info into Word would be to do a Mail Merge in Word. Word allows you to specify an Access database as the data source for the mail merge.

by d-ced

The easiest way to get the info into Word would be to do a Mail Merge in Word. Word allows you to specify an Access database as the data source for the mail merge.

This discussion is closed to new replies.