Web Development·12,052 discussions

Copy text from field in Access to Word

Locked

Hello,

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

Topic

Reply To: Copy text from field in Access to Word

In reply to Copy text from field in Access to Word

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.

Reply To: Copy text from field in Access to Word

In reply to Copy text from field in Access to Word

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.

Reply To: Copy text from field in Access to Word

In reply to Copy text from field in Access to Word

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.

Reply To: Copy text from field in Access to Word

In reply to Copy text from field in Access to Word

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.

Reply To: Copy text from field in Access to Word

In reply to Copy text from field in Access to Word

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.

[Author]

Replies