Creating Birthday & Anniversary Labels

[TeeStew]

We have Power Church 11.5

Our church sends out monthly anniversary & birthday cards, and I know how to create a report for that. We print them out in date order. Works great for a report. This print out does not work for labels because it only prints all in one column on the left and puts all the dates in a second column.

What I want is a set of labels that includes addresses for the current month of anniversaries, and birthdays.

I have tried several things. I thought perhaps that the solution was to export the report into Word. I did but then it would not let me open the document and gave an error message. I later found out from a tech that our version of Power Point won't let you do that.

I got on the phone with Power Church's tech support and he thought he figured it out, but when I printed them out, they were not the same names and addresses. They did not match up with my other report which is correct.

Here's what he had me do. He had me go into Membership - Personal Profile - Mailing Labels --

Then told me to choose Personal -- All -- then deselect the options such as No Address - Not communing etc. (according to the specs I needed. Same specs that I used in the report, So I deselected the following: baptized, contributing, deceased, no address, not communing, potential member, transferred out, visitor, removed by council, non.)) Then I defined a range for dates for birthdays. This was for the month of August. He told me to put in 09/01/100 for the start range and 09/30/2012 for the end range. Then I was to leave ALL selected where it says Tagged. Sort options were Date (month/day). I wanted one label per person.

What I got did not match up in the lease with my birthday / anniversary report for that month which I put in the same specs for.

Currently I am having to hand type all of these to get labels. There's got to be a better way. Or is this version in capable of doing this?

[NeilZ]

Did he really tell you to use the starting date of 09/01/100 ???

If all you're looking for is the birthdays falling within September, then you should be using the MM - DD columns next to the Birth Date.

So the dates should be: 09 01 to 09 30

[TeeStew]

Correction . Starting date was 09/01/0001

I will try the date slots next to Bday and see if that works. I tried that originally but didn't try it using the 0001 year. I was told not to use those slots by the tech.

[TeeStew]

I tried plugging in 10/01 - 10/31 for birthdays and anniversaries, and I left ALL selected. when I go to print it tells me no records selected.

[NeilZ]

I tried plugging in 10/01 - 10/31 for birthdays and anniversaries, and I left ALL selected. when I go to print it tells me no records selected.

Don't do both at the same time ...

[TeeStew]

I did it only for birthdays and it worked and they matched up with the other reports. Thanks for your help.

[NeilZ]

I did it only for birthdays and it worked and they matched up with the other reports. Thanks for your help.

You're welcome.

This is why it didn't work when you tried for both. Each date range acts as a filter, trying to find both date ranges meant that you would only pull up those who had birthdays between 10/01 aand 10/31 AND anniversaries between 10/01 and 10/31.

If there was no one matching both filters, you get nothing.