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

  • Thread starter Thread starter Mike NG
  • Start date Start date
M

Mike NG

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 datasheet 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 sheet 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
 
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.
 
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.
Click to expand...
Thanks Duane.

I've decided it's too much hassle to give reports a go, so will just
stick to opening word using code (automation) as I did before.

I see what you're doing regarding the export - in fact that's what I was
doing manually within the code of my excel spreadsheet in the old
version. Does this have any advantages over linking to the same query in
Access from the mail merge main document
 
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.
Click to expand...
Please can you tell me how you automate exporting a query out as a "MS
Word Merge" file.
 
Download the file that I suggested. There is code in it that sends the
results of a query to a merge format file.
 
Download the file that I suggested. There is code in it that sends the
results of a query to a merge format file.
Click to expand...
Cheers - got it. Too tired to try anything out tonight, and I may have
changed my mind and just refer to my query instead from Word
 
Back
Top