Word output from within access 1

[eocheng]

Hi,

I'm looking for a guidance/examples on how to format a word document using VBA.

ie.
1. how to add a header/footer
2. how to add a carriage return between fields
3. how to add an image

currently, I have it set up to write all the data to a string and then output the string using the typetext strOutput property.

Any comments/help are greatly appreciated. Thank you kindly.

e

 

[Lightning]

If you have access to the Access Developer's Handbook, Chapter 12 gives a very good example of how to do this using Word bookmarks.

Basically, open a word document using an existing template with the bookmarks established, then export the data from Access to each individual bookmark, then save the document using whatever name.

    Set objWord = New Word.Application
    objWord.Visible = True
    Set objWordDoc = objWord.Documents.Add(Template:="MyTemplate.dot", NewTemplate:=False)
    With objWordDoc.Bookmarks
        .Item("FirstField").Range.Text = Me.MyField
        .Item("SecondField").Range.Text = Me.MySecondField
    End With

'Save a backup copy of the letter to the backup folder
    objWord.ActiveDocument.SaveAs FileName:="C:\MyPath\" & [MyDocName.doc"

HTH
Lightning

 

[eocheng]

Hi Lightning,

Can always count on lightning providing lightning fast results! It worked perfectly!

Thank you for your time and help. It is greatly appreciated!

e