This macro will convert imported birthdays to recurring events.ĭim appItem As Object 'Outlook.AppointmentItem On the Auto Account Setup page, enter your name, your Gmail address and your Gmail password (or the app password), and then choose Next. MyFolder.Items(i).Anniversary = myanniversary In the Outlook app, choose File > Add Account. ' Replace 'today' with the correct birthday & anniversary ' Set today as the birthday & anniversary Myanniversary = myFolder.Items(i).Anniversary ' Copy the correct birthday and anniversary to a variable ' If you want to see that it's working, uncomment this line If you prefer to use the folder picker, change the Set MyFolder line to Set myFolder = Session.PickFolder This macro uses the Contact folder you are looking in. The add-ins offer more features (and can offer a high return on investment) if you sync a lot, but for one time use, a macro is quick and effective. You have two choices: a macro or an add-in. When you import Contacts (or sync with a smartphone) the birthdays are not added to the calendar.
#ADDING GMAIL TO OUTLOOK 2018 HOW TO#
ReminderMinutesBeforeStart = 24 * 60 * intDaysįor help using the VBA Editor, see How to use Outlook's VBA EditorĪdd Birthdays and Anniversaries to calendar InStr(Item.Subject, "Birthday") > 0 Or InStr(Item.Subject, "Anniversary") > 0 Then Private Sub mcolCalItems_ItemAdd(ByVal Item As Object) Set mcolCalItems = objNS.GetDefaultFolder(olFolderCalendar).Items Set objNS = Application.GetNamespace("MAPI") If you want a longer reminder period, you will need to change the reminders on each birthday or anniversary or use VBA to set the reminders. When you create a new contact and specify a birth date, Microsoft Outlook automatically creates a recurring annual event in the Calendar folder for contact's birthday, but it doesn't set a reminder unless you have Outlook set to add a reminder to all new appointments (and in that case, it uses the default reminder time, usually 15 minutes). There is also a VBA sample there to remove the events from the calendar as soon as the Contact creates it. See Removing Birthdays and Anniversaries for an easy way to remove the dates from Contacts and the events from the Calendar. See the Tools below for utilities that can trigger the update.
#ADDING GMAIL TO OUTLOOK 2018 FULL#
In order to have them added you need to either edit the contact's name (clicking the Full Name button and saving the contacts is sufficient) or edit the Birthday and Anniversary fields to trigger an update. However, if you import a contact list or sync with a handheld device, these events are not created in the calendar.
Note that if you do this, Outlook may recreate it at some point. Put the dates in the Notes field or a user defined field. If you don't want the events added to your calendar, don't enter dates in the birthday and anniversary fields.
0 kommentar(er)
