Export from Access to Word in Customized Format

[Gavin]

Hi, is there a way to export from Access a database with the fields; Surname,
Initials, Year, Title, Journal Title, Volume, Issue, Page Numbers, into a
Microsoft Word Document so the Document is a list of Publications (or
References) formatted in the Harvard Style, i.e. Surname, Initial., Year.
Title. <i>Journal Title</i>, Volume(Issue), Page Numbers.

 

[Larry Daugherty]

Your issue isn't with the data in Access, it's with the *formatting
and display* of that data in Word.

If you can write the VBA in Word to accomplish the task to your
satisfaction then you can use Automation and run that code from Access
to achieve what you've asked.

You would have to know something about using VBA in Access and Word.

HTH

 

[Gavin]

Thanks Larry

Your issue isn't with the data in Access, it's with the *formatting
and display* of that data in Word.

If you can write the VBA in Word to accomplish the task to your
satisfaction then you can use Automation and run that code from Access
to achieve what you've asked.

You would have to know something about using VBA in Access and Word.

HTH