[AccessD] Using word from Access

Hi,

maybe this will help:

first create the bookmarks in the word doc to use!!

'reference microsoft Word x Object Library
    Dim WordObj As Word.Application

    Set WordObj = CreateObject("Word.application")
    Set objWord =
WordObj.Documents.Open(FileName:=App.Path &
"\test.doc")
    objWord.Application.Visible = True
    With WordObj.ActiveDocument
      With objWord.Bookmarks
        .Item("Bride").Range.Text =
rst.Fields!Reception_Location
        .Item("Groom").Range.Text =
rst.Fields!Reception_Location
        .Item("Reception").Range.Text =
rst.Fields!Reception_Location
      End With
    End With


I guess you want to export the data to Word because
you (or someone else) need(s) to do some editing? If
not use a Report! Saves a lot of trouble.

HTH

Sander
--- Ryan Smethurst <RSmethurst at UxbridgeCollege.ac.uk>
wrote:
> Hi All,
> 
> I am trying to set up an MS Access database that
> will produce labels in MS Word based on data from a
> recordset.
> 
> Does anyone have any useful pointers that would help
> me get started.
> 
> Thanks
> RyanS
> 
> 
> 
> 
> 
> The information or opinions in this message
> (including
> any attachments) are those of the author and are not
> 
> necessarily those of Uxbridge College, which
> disclaims
> responsibility for loss or damage arising from its
> use to
> the maximum extent permitted by law. E-mail messages
> sometimes go astray. This message is sent in
> confidence for the addressee only. It may contain
> confidential or sensitive information. The contents
> are not to be disclosed to anyone other than the
> addressee. Unauthorised recipients are requested to
> preserve this confidentiality and to advise the
> originator.
> immediately and to delete the message without
> copying,
> altering or disclosing its contents. E-mails to or
> from
> Uxbridge College may be monitored by the College in
> accordance with its current policy.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com