Home
Prayer for Husband
Support
Accounting Packages Church Accounting
Accounting  eBook
Contribution eBook
Blogs Site Blog
Free Stuff Free Newsletter
Free Spreadsheets
Spreadsheet Reviews
Customize Sheets
Freebies
Accounting Definitions
Basic Accounting
Fund Accounting
Petty Cash Account
Financial Statements
Church Software
Questions/Comments
Contributions Contributions
Annual Statement
Non-Cash Receipt
Love Offerings
Gift to Individual
Membership Software Shepherdbase
Churchtrac
Administration  Church Budget
Audits
Internal Controls
Staff
Reimb Expenses
Tax Exempt Status
Records Retention
Track Receipts
Clergy/Minister Clergy Tax
Housing Allowance
Fringe Benefits
Percentage Pay
Employee or Not
Ministers W-2
Estimated Taxes
Opt Out SS
Payroll Payroll Set Up
W-2/W-3
1099-MISC
Form 941
Annual To-Do List
Misc. QuickBooks
Cut Back Tips
Office Supplies
Budget Tips
Fundraiser Tips
Appreciation
Resources Church Web Site
Resources/Links
SiteSearch
Information About Me
Contact Me
Terms of Use
FAQ
[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Mail Merge Question

Question about using mail merge for annual contribution statement:

Vickey,
We've used your contribution spreadsheets this past year, and they have really been a tremendous help. I'm wondering if you have any documents that explain how you use them for a mail merge. I have no problem researching how to do a generic mail merge, but I wonder if you can give some guidance on how I would do it with these sheets & what info I can include in the letters to the contributors.

In any case, I appreciate the wonderful work you do to help others who, like me, have very limited or no experience with accounting, but want to be able to help out at our churches.

Answer

You can download an example of an Annual Contribution Statement on my freebies page. You can customize it to fit your church.

As far as doing a mail merge, I am embarrassed to say...I have no idea how to do a mail merge...our church secretary always handled that wonderful chore :-)
However, I will contact her and ask her to comment on your post and explain how she always did it before she built her own contribution tracking database.



Church Accounting Package

www.freechurchaccounting.com





Comments for
Mail Merge Question

Average Rating starstarstarstarstar

Click here to add your own comments

Jan 11, 2010
Rating
starstarstarstarstar
Mail Merge for Contributions Question
by: Terressa

I'm the church secretary for Vickey's church. She asked me to comment on on the Mail Merge question for the annual contribution statement. I've used mail merge just in Microsoft Word to merge letters, but I've not used it to merge data from Excel, although I know it can be done. When I was using Vickey's contribution spreadsheet, I just took the amounts from the front sheet and hand put them into the annual statement. But here is a link to Microsoft Office Training that will explain how to do it: http://office.microsoft.com/training/training.aspx?AssetID=RC011205671033

Sorry I couldn't be of more help with the mail merge question. Since I created Shepherdbase I don't work so much in Excel. Feel free to contact me with any questions at terressa@freechurchforms.com.

Jan 13, 2010
Rating
starstarstarstarstar
Thanks for the info
by: Anonymous

Terressa,
Thanks so much for your response. I'll check out that training you refer to & should be fine. Was just looking for any tips you folks might have. I'll also check out your database.

Click here to add your own comments






 

Custom Search

Church Accounting Package

Church Accounting Package

  • Want to learn some basic church accounting basics?
  • Need to know how to fill out a noncash donation receipt?
  • How about some tips on setting up a fund accounting system?

Click here for details


Testimonies

Would Highly Recommend. Took the mystery out of Church Accounting for me ...more...

Excellent Book! I highly recommend these books. They are a necessity, WRITTEN IN PLAIN ENGLISH!
Errol James

Real Eye Opener. Not knowing a thing about church finances, this was a real eye opener and a great way to get us started ...more...

Very Helpful and Detailed I would recommend these books to everyone, I am from Canada and would also recommend it to all of the Canadian people involved in the Finance part of the church. Very helpful and detailed. A must get!! ...more...

more testimonies on bottom of this page...


Small business accounting software




Free Accounting Spreadsheets

when you...

Subcribe to my free newsletter: Stewardship


Testimonies

Your spreadsheets work wonderful-I have Pastored for 17 years in 3 different churches, and this is the best and easiest finance program for the Church that I have seen yet!
Pastor Tim

Thank you so much for sharing your spreadsheets! I expect the Lord will reward you in heaven for helping those of us that needed some quick help...more...
Darla

Free Spreadsheets I've downloaded several of your spreadsheets and I had no problem with them. They have helped me to keep better records, also they are well structured professionally... more...
Mary

The free accounting spreadsheets were a life saver. I was able to immediately start using them and they saved me more time than I could ever imagine being able to save! I'm now organized!... more...

more testimonies...


Recommended Products





Shoeboxed Works Great With Evernote


Bookkeeper 2011