automating word with access data

P

Peter Kayser

Hi NG,
I'm looking for a solution to fill different Word-Forms with Access Data.
I would like to customize my routine with data from a table.
Has anybody an idea how to implement somtihng like the following steps

wordapp.selection.MoveRight Unit:=wdCell

to

strExecute = "selection.MoveRight Unit:=" & rst!myfield
wordapp.(execute result from stringhandling)

THX for help
Peter
 
T

Tom van Stiphout

Filling Word forms with Access data is done using MailMerge in Word.
Going at it a cell at a time is probably not needed.

If you know VBA and Automation well, you can automate that MailMerge
process, either in Word or in Access.

-Tom.
 
P

Peter Kayser

Hi Tom,
thx for tip.
Unfortunaly I can't fix all my problems with mailmerge. For example
FormFieldCheckboxes coudn't be filled in this way.
I'm still searching a way to generate an execute ole-commands.

-Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top