Send birthday greetings to your customers

Updated: May 4, 2007

Give a personal touch to your customer service by sending a birthday e-mail to customers. You can create a birthday list, create an e-mail template for the birthday wish, and send your customers birthday greetings every month in just a few clicks.

First, you’ll need to ask your system administrator to make some simple customizations to contacts.

*
**
**
On This Page
Customize your Contact form for a birthday month and dayCustomize your Contact form for a birthday month and day
Make a birthday list from your contact listMake a birthday list from your contact list
Create a birthday greetings e-mail templateCreate a birthday greetings e-mail template
Send your birthday greetingsSend your birthday greetings

Customize your Contact form for a birthday month and day

Microsoft Dynamics CRM treats dates as a single piece of data and does not separate the month and day from the rest of the date. By adding birthday month and day fields to the Contact form that are automatically calculated, whenever a user enters a birthday, the birthday month and day fields will be updated, and can then be used to send birthday greetings.

Important

Because the automatic calculation happens only when data in the Birthday field is changed, this process is best to do during deployment of Microsoft Dynamics CRM, and before data is migrated into Microsoft Dynamics CRM.

Customizing the contact form requires the default System Administrator or System Customizer security role or equivalent permissions.

1.

Under Settings, click Customization, and then click Customize Entities.

2.

Double-click the Contact entity, and then in the Contact entity form, under Details, click Attributes.

3.

Click New, and in Display Name, type Birthday Month. Change the Type to int, and then click Save and Close.

4.

Click New, and in Display Name, type Birthday Day. Change the Type to int, and then click Save and Close.

5.

Under Details, click Forms and Views, and then double-click Form.

6.

On the Details tab, click the Personal Information section, and then click Add Fields.

7.

In the Add Fields dialog box, select the check boxes for the two new attributes you added, and then click OK to close the dialog box.

8.

For each new field that you added to the Personal Information section on the form, click Change Properties.

9.

In the Field Properties dialog box, on the Display tab, select Disabled on the form, and then click OK. A disabled field will appear as dimmed on the form.

10.

Select the Birthday field, and then click Change Properties.

11.

In the Field Properties dialog box, click the Events tab, click onChange, and then click Edit.

12.

In the Event Detail Properties dialog box, on the Details tab, select the Event is enabled check box to enable the event, and in the text box, paste the following script:

if (crmForm.all.birthdate.DataValue != null)
{
var bd = crmForm.all.birthdate.DataValue;

crmForm.all.new_birthdaymonth.DataValue = (bd.getMonth() +1);
crmForm.all.new_birthdaymonth.ForceSubmit = true;

crmForm.all.new_birthdayday.DataValue = bd.getDate();
crmForm.all.new_birthdayday.ForceSubmit = true;


}
else
{
crmForm.all.new_birthdaymonth.DataValue = null;
crmForm.all.new_birthdaymonth.ForceSubmit = true;

crmForm.all.new_birthdayday.DataValue = null;
crmForm.all.new_birthdayday.ForceSubmit = true;
}

13.

On the Dependencies tab, in the Available Fields list, select the Birthday Month and Birthday Day fields and then click Move data to the right icon to move the field to the Dependent Fields list.

14.

Click OK to close the Event Detail Properties dialog box, and then click OK to close the Field Properties dialog box.

15.

Click Save and Close on the Form: Contact form.

16.

On the Entity: Contact form, on the Actions menu, click Publish.

17.

On the Entity: Contact form, click Save and Close.

Now when a user enters a value in the Birthday field on the Contact form, the Birthday Month and Birthday Day fields will be automatically filled in.

Make a birthday list from your contact list

You can create and save a query that displays the birthdays for all your contacts who have a birthday entered in their contact record. Then, you can use this same query each month to send a birthday greeting in e-mail.

1.

In the Contacts list, on the Standard toolbar, click Advanced Find.

2.

Click Show Details, and create a search that looks like this, which will find only contacts that have both a Birthday Month value and an e-mail address.
 

Advanced Find form showing criteria

Note

All criteria are selected from under Fields in the Select list.

3.

Click Edit Columns, and under Common Tasks, click Add Columns.

4.

Select the Birthday Month check box, and then click OK.

5.

Under Common Tasks, click Configure Sorting.

6.

In the Column box, select Birthday Month, and then click OK.

7.

In the Edit Columns dialog box, select the Birthday Month column (you may have to scroll to the right to see it), and then use the green arrows under Common Tasks to move Birthday Month to the left so that you will be able to see it on the Advanced Find search results page, and then click OK.

8.

Click Find and verify the results are what you expected.

9.

Click Back to Query, click Save As, type the name of the view (such as Birthday List), and then click OK.

This saved view will be available from the Contacts list page at the bottom of the View menu.

Tip

You can share this view with other people in your organization. After you have shared it, it will appear in the My Views section of the View list in the Contacts list.

1.

On the Standard toolbar, click Advanced Find.

2.

Click the Saved Views tab.

3.

Select the search, and then on the More Actions menu, click Sharing.

4.

Click Add User/Team, click Find, and then in the Look Up Records dialog box, select the users you want to share this view with.

5.

Click OK to close the Look Up Records dialog box, and then OK again to close the Who would you like to share the selected saved view with dialog box.

Create a birthday greetings e-mail template

Now that you have made it easy to determine which month a user’s birthday is in, you can create a personal e-mail template to use to send birthday greetings.

1.

Click Workplace, and then click Personalize Workspace.

2.

In the Set Personal Options dialog box, click the E-mail Templates tab, and then click New.

3.

In the Template Type list, select Contact, and then click OK.

4.

On the E-mail Template form, type a title, such as Birthday Greetings, and a description. The title and description are not displayed to the recipients of the e-mail messages that are created by using this template.

5.

In the Subject line, type a greeting, such as Happy Birthday.

6.

In the body of the message compose your message.

1.

To add a field that will insert the customers’ name, on the Actions toolbar, click Insert/Update.

2.

In the Data Field Values dialog box, click Add.

3.

In the Record Type list, select Contact, and in the Field list, select First Name, and then click OK.

4.

Type your message.

Tip

Although you cannot insert images or HTML directly into Microsoft Dynamics CRM e-mail messages or e-mail templates, you can use the copy feature in Internet Explorer to copy an image from a Web site and paste it into the e-mail template. The image is available as long as the Web site can be accessed.

5.

To close the Data Field Values list, click OK. Your template will look like this:

Sample e-mail template

7.

Click Save and Close.

8.

To close the Set Personal Options dialog box, click OK.

Send your birthday greetings

Before you can send your birthday greetings, the Bulk E-mail Service must be running on your Microsoft Dynamics CRM server. For more information, see the Help topic “Start the Bulk E-mail service on the Microsoft Dynamics CRM server.” (You can open Microsoft Dynamics CRM Help by clicking Contents on the Help menu in the Web application.)

1.

In the Contacts list, in the View box, select your saved view. You may have to press F5 on your keyboard to refresh the screen before the saved view appears.

2.

Select all the contacts who you want to send birthday greetings to.

3.

On the Actions toolbar, click Send Direct E-mail birthdaylist3.

4.

In the Send Direct E-mail dialog box, under Contact Templates, select the birthday template you created.

5.

Click Send.

The birthday message will be in the History folder for every contact to whom you send a message. Be aware that the e-mail message will not be sent if the contact record has Do not allow e-mail selected.



Was this information useful?