Mail Merge problem

[cheyenne2002]

I need to do a mail merge with (Word) and my database. My database is a list of donations and the payments made toward those donations. I have a history of the payments and donations from 2003 thru 2006.

In my letter (Word) I need to put a history of giving over the past few years. I'm totally confused at how I can do this. I'm staring at the data and see it there and just can't seem to grasp how to get it the way I need it in Word.

Each payment is a separate record so I might need to add a few together to get the total giving for one of the years or it might be a single payment. There might also be a year that the donor did not make a donation and therefore no payment.

Does anyone have a suggestion as to how I can get this done. I just found out I have to have this merge done TODAY so the letters can be FedExed out for delivery Wednesday. I'm not stressed!!! NOT

Thanks for any help and suggestions. My database has other issues which I need to address, but this is my main priority today.

Sharon

 

[Remou]

You cannot do this in Word, without a good deal of difficulty. You can:

* Create a report and use a little code and SendObject to email each page as an attachment.
* Create a report that outputs to PDF and use Outlook Automation or CDOs to email the PDF.
* You can use various recordsets to build an email (Outlook, CDO, or SendObject)
* You can read a report saved as HTML or RTF into the body of an Email (Outlook, CDO, or SendObject)

I think that's about it.

 

[dhookom]

The quick and dirty method might be to concatenate the donation records into a single expression with tabs between fields and crlf between records. This could then be used to simulate a table in your merged document. There is a generic concatenate function with sample usage at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]