Is it possible to automate this?
Insert information from a database or other data source into an existing Word document
What I have to do is insert a MS Excel spreadsheet into MS word Fax cover document. The data is exported to Excel automatically from access. I want the cursor to be set on a particular line (e.g. Line 10) and then automatically insert the table from that point onwards.
Is this possible???
The code am currently using is as follows:
<pre> strFileName = CSTR_DOCSPATH & "BCPSOURCE.xls"
DoCmd.OutputTo acOutputQuery, "Citco", acFormatXLS, strFileName, False
Set objWord = GetObject(CSTR_DOCSPATH & "Citco.doc", "Word.Document")
'set value to Date
Set rstCitco = db.OpenRecordset("tblCitco", dbOpenDynaset)
With rstCitco
TDate = rst![ td ]
End With
'Make word visible.
With objWord
.Application.Visible = True
'Execute the mail merge.
With .MailMerge
.destination = wdSendToNewDocument
End With
Set appWord = .Application
End With
appWord.DisplayAlerts = wdAlertsNone
appWord.DisplayAlerts = wdAlertsAll

What I want to do after opening the Citco.doc is to go to a certain line e.g. Line 10 and the output certain column to certain column from excel into word (citco.doc).
Can this be done??