2012-05-27, 20:38 #1
- Join Date
- May 2012
- Thanked 0 Times in 0 Posts
Merging into sorted groups without using directory?
I'm working on a project for my father-in-law, who is a pastor of a small church. He has a long list of prayer requests, sorted into 8 categories. He wants a list of the active requests inserted into his church bulletin, so that each week when he creates the new bulletin, the updated request list is already there.
I am hoping to set this up through a combination of an Access database and a Word mail merge. I've set up the database, entered a representative sample of requests in each of the 8 categories, and put together a form for him to use for entering new requests, updating existing ones, etc. I also set up a query that pulls just the active requests. (For now, at least, I have it filtering for requests that have an "End Date" after today in the table. That may change later, based on my father-in-law's instructions.)
So now I'm ready to actually create the mail merge. I'm up to 50 tries now, but I still can't get it to do what I want. I can get closest to the desired results by using a Directory setting, but it's still not quite right. Additionally, using the Directory setting would require extra steps on his part this week (merging to a new document, copying that and pasting it into the bulletin file, etc). I would prefer to code it all into the original document rather than to use a Directory set-up where you have to merge to new doc to get the results; I need it to be as user-friendly and uncomplicated as possible! (He lives 6 hours away, so if things aren't working right that leads to 2-hour "tech support" phone calls which I really want to avoid!)
Here is what I need:
--8 sections with descriptive headers (for each of the 8 prayer request categories)
--(The names need to be something other than the "Type" code from the database. Since I'm using a look-up in the database, pulling the type from a second table, the official "Type" code that's pulling in is just a number--1-8--rather than the actual Type name, such as "Christian Sympathy".)
--Within each section, the names of the people listed as having those types of prayer requests
--Before each name, a cross icon (easy to add through Symbols, though I can't always get it to show up for each record when merging)
--Each section set up as a paragraph, with each cross and name immediately following the prior name (that is, no forced line breaks)
--A line break after each section, before the next section
Any suggestions on how I can make this work? Thank you for any help you can provide!!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!