Mail merge

[Clemens]

Hi, I hope someone is able to help me with a simple explaination 'how to set
up mailmerge in access using only acces'. If possible offcourse.

What do I have:
A simple table with multiple fields.
The table is the result from a weekly import of an excel file. In de table
usernames are inserted and can be used for sending e-mail to.
I would like to create a report , based on a query which includes all
records updated after a specificied date. Each report displayes 1 record with
several fields.
I would mail each report to users which are a result from the query.
This mail must be send only when I press a button on the switchboard.

Is this possible without the use of word or excel?

 

[Evi]

Yes. Sort of. I'm not sure which bits you can't do so ask again if anything
doesnt' make sense. Set up a report with the details in it.
You will need to put differently formatted bits in a different label or text
box
The 'boiler-plate' text can be labels if necessary

Use a form to send your report.I suggest that you filter the report using
textboxes combo boxes or listboxes which you will put in the form for that
purpose.
Help available if you need it.
If you insert a Command button into your form one of the options the wizard
will give you when you choose Report Options is to Mail Report. When you
press the button, you get several options to choose from.

The Sort Of is because only the Snapshot option gives you something that
looks like the original report. The other options strip away alot of the
formatting. Try them out by mailing the report to yourself and see if any of
them are satisfactory.

For the snapshot to work, you need to mail your recipient (if they don't
have access) the Snapshot Viewer to install on their machine)

I'm using Acc2000, later versions may have improved on the mailsending
formats.

If that gives you the results you want, you can then go into the code behind
the button and enter the criteria for filtering the report before you open
it

Give us your report name and the name of the Date fields and we can help you
with that if you need help.

Evi

 

[Evi]

For the best results you can use Stephen Lebans brilliant ReportUtilities
which lets you output reports as Word Document, HTML or PDF attachments.
http://www.lebans.com/ReportUtilities.htm

Evi