About TameraLee

Try this it worked out pretty well for me. What I wanted to do was to send out birthday emails every week to customers who have a birthday within that week. I had a DOB field for my contacts, but apparently you can't search/ select from this field because it is a 'date' field, not a 'text' field. SUPER MEGA annoying btw! So here's what I did. Export your contacts to an excel file. Open that up and add three fields next to your DOB field. I named mine, "Birth Day", "Birth Month", and "Birth Year". This next part is a little tricky. Under "Birth Day", type =text(F2,"D"). Where F2 is the original DOB field. You want to pull from that DOB field and just get one number, the D (day) field. Same thing goes for month and year. Type =text(F2,"M") and =text(F2,"YYYY"). That will get your three separate fields. Now on constant contact, go to my settings and under contact settings click on manage my custom fields. Add the three fields, birth day, month, and year. This way you can use the advanced search feature to search for whatever day/month/year you need. Now you can upload your new list to constant contact. Making sure to match up the fields correctly. And just before you upload them you might want to click the button that says you just want to update contacts, not to add any new ones. The only problem I ran into was the limited file size when uploading. I guess it's 1.3MB for .csv. I had to break my list up into two parts to get it done. But now when I want to send a birthday email, I just advance search whatever month/day/year I'm looking for, tag them (you might have to do each day separately), and then send the email to the tags. So ya, it takes a little bit of work, but a lot less work for me than what I was doing. Hopefully this helped in any way.  ... View more

So here's how I did it, and it worked out pretty well. What I wanted to do was to send out birthday emails every week to customers who have a birthday within that week. I had a DOB field for my contacts, but apparently you can't search/ select from this field because it is a 'date' field, not a 'text' field. SUPER MEGA annoying btw! So here's what I did. Export your contacts to an excel file. Open that up and add three fields next to your DOB field. I named mine, "Birth Day", "Birth Month", and "Birth Year". This next part is a little tricky. Under "Birth Day", type =text(F2,"D"). Where F2 is the original DOB field. You want to pull from that DOB field and just get one number, the D (day) field. Same thing goes for month and year. Type =text(F2,"M") and =text(F2,"YYYY"). That will get your three separate fields. Now on constant contact, go to my settings and under contact settings click on manage my custom fields. Add the three fields, birth day, month, and year. This way you can use the advanced search feature to search for whatever day/month/year you need. Now you can upload your new list to constant contact. Making sure to match up the fields correctly. And just before you upload them you might want to click the button that says you just want to update contacts, not to add any new ones. The only problem I ran into was the limited file size when uploading. I guess it's 1.3MB for .csv. I had to break my list up into two parts to get it done. But now when I want to send a birthday email, I just advance search whatever month/day/year I'm looking for, tag them (you might have to do each day separately), and then send the email to the tags. So ya, it takes a little bit of work, but a lot less work for me than what I was doing. Hopefully this helped in any way.  ... View more