Sending one record to a report or Word doc?

P

pvdalen

Hi all,

I have a form with specific customer information that I'd like to send to
either a report or MS Word document. I'd like the report/doc to be a form
letter that gets populated with the customer data on the record currently
viewed in the form.

I thought this would be simple, but, unless I'm missing something obvious,
it doesn't appear to be. In the command button, do I have to do something
like assign the open record to the report/doc as a recordsource?

Sorry if this is basic, but it's just not clear to me exactly how to send
the data to the report/doc.

Thanks very much,
Paul
 
A

Alex White MCDBA MCSE

Hi,

couple of things, when in preview mode of a report you have a word button at
the top of the screen, this will do a job of making your report look totally
different in an rtf file, you may be lucky and it looks ok.

or get Albert's word merging solution, although I have written my own, his
is much more streamlined than mine and you will get results a lot quicker..

http://www.members.shaw.ca/AlbertKallal/wordmerge/
 
P

pvdalen

Thanks very much, John and Alex. This looks like exactly what I need! I'll
give it a go and let you know if I've any more difficulties.

Paul
 

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