Re: Simplest way to create a report to look like a mail merge document

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 12:23:09 -0600

The most functionality comes from merging Access records in Word. I usually
export the query or table to a Word Merge formatted file. I can then open
Word and merge the file into a letter or whatever as needed. Most of the
time, I automated this with code.

For simple mail merge letters without Word, consider the Query By Form
applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
allows users to enter the text for a document and press F3 to insert a field
from a table. The results are merged with your records and printed in a
report. You could also send the report to Word for further formatting. 

-- 
Duane Hookom
MS Access MVP
"Mike NG" <sweepdog@deadspam.com> wrote in message
news:1nmcTMCQ5zUAFwPu@ntlworld.com...
> I believe from doing google searches and setting up some practice Forms,
> I'm in a position to replace my rather clunky database written in Excel
> VBA (using Forms) c/w an excel data*** with an Access system
>
> One thing I had as part of this was a mail merge main document which I
> called (c/w writing an appropriate data file).  This was very easy to
> set up as I just typed as I would a normal document, format it, printed
> it to test it, and adjust it appropriately
>
> Obviously the way to go in Access would be a report.  The wizard is a
> bit of a pain cos I don't need the field names, have to delete the
> footers and headers etc, have to delete the red record separator and
> insert the page break character.
>
> Design mode isn't a right lot better, but is there an easier way where
> you can effectively get an A4 *** and type the data as you go along
> where things like left justification are done automatically for you -
> otherwise you have to rely on the align and spacing options which is a
> bit naff in my opinion
>
>
> Also, I have looked in the help for "mail_merge" and it says this
>         In the Database window, click the name of the table or query
>         (Access database only) you want to export, and then on the Tools
>         menu, point to Office Links and click Merge It With MS Word.
> but I can't for the life of me see this menu either with a table or a
> query selected, and I do have the menu fully dropped with
> not-so-recently-accessed items visible.  Has anyone else seen this in
> Office 2000
> -- 
> Mike
> Please post replies to newsgroup to benefit others
> Replace dead spam with ntl world to reply by email