Search results

I ended up creating two forms--one simple and one with subform. The one that has the subform is actually how I'd like my letters to appear: It shows the donor's name and address and the subform shows all their individual donations. THAT'S exactly what I"m after in a thank-you letter. P.S. I DID...

Does it matter if there's a subform? I could view the form by donations which would be a simple form--or I could view by donor which would give me a form with subform.

Okay, they are now in my donations database...

Sorry to create confusion by starting this second thread. To anyone who is reading this, I was unable to follow the instructions by "AccessJunkie" in the original thread on this topic because I got stuck immediately trying to figure out what a client accdb file was--and what "client copy" meant...

Okay, just got that done. But I'm curious as to why it says it's saved as an Access 2007 db--why not 2010 since that's what I have? But I've got the .accdb extension now.

WHAT should be in the database I downloaded? Did I download the correct database? As I wrote above, I downloaded "WordMerge2008" from this page: http://www.kallal.ca/msaccess/msaccess.html under the header, "Super Easy Word Merge"--is that what you're talking about? It saved as .mdb --should it...

Before leaving, I did download "WordMerge2008"--is that what you were referring to?

I have to leave for a few hours but will be back. So you mean Albert Kallal has a sample db I need to download? I didn't see anything at first glance, esp. when scrolling all the way to the bottom. Do you mean under his heading of "Super Easy Word Merge"? Yes, I have Access 2010. Later!

WHAT sample/example database? I'm lost (again).

Edit: Sorry--if you just meant to save it in a folder, it is. Properties shows it as: C:\Users\Owner\Documents\Word But where do I find GUIWordTemplate? Is this back in Access? Are you talking about my query?

Have it ready and waiting...

I mean that what I have now is the Access template "Charitable Contributions web database" converted to a desktop database, keeping everything as originally designed except for my addition of a query to enable me to create a donor thank-you letter. The template only produced reports showing...

Um...how do you mean? I've entered some donor information and it all seems to be working correctly, so I guess all the "pieces and parts" are there... The only thing I've added myself to this db is a query to combine both the donor personal information and the actual donations so that all of...

I've got the mail merge letter open now--along with the "Thank You Query". Now what?

Okay, done. Have a letter that thanks donors--one letter per donation. (Have to figure out how to change the donated amount to appear in properly formatted currency as right now it's just showing the number: 25 or 150 etc.)

Oh for Pete's sake--I kept wondering if you had left for the day/night--not realizing we were on a 2nd page now. Duh. :o But I have now copied everything from the web database. I am in the process of adding some data to see how it works. Was also going to try creating a letter as I had in my...

Hold on--I just got it. I mean I think I've actually imported the tables from the Charitable Contributions web db (CCwdb). Used the Access icon from Get External Data... Later: but I was only able to import the tables, nothing else. Trying to follow that other thread you referred me to in order...

How is editing my previous post step one in the mail merge? You completely lost me on that... Okay, I have a completely empty test database .accdb. So now what?

:confused: Oh dear, I'm afraid I'm more of a novice than you or I thought...I don't even know what the Client copy means. I had tried to edit my previous post but temporarily lost Internet connection--was wondering if I should forget about this conversion and simply adjust my own db. Would...

I had another post on being unable to figure out that procedure. Stuck at the very first step of importing "all the web tables, client forms, and client reports from the web copy into the client file." I've created a blank db, but where do I find a command to import? At the tab "External Data"...