Outlook Mail Merge

[Artemus]

I want to merge out a letter to a list of contacts who have calendar
appointments. Not only do I want to have the contact fields like name and
address show up, but I also want to include appointment fields like start,
end, location show up from each of the associated appointment(s).

After I created the contacts and appointments I associated each contact with
each of the appropriate appointments by clicking on the Contacts link in the
lower right-hand corner of the appointment. I've also confirmed that the
appointments show up on the Activities tab of each contact. The start, end,
location fields show correctly on the tab view of each individual contact but
but those same fields don't show on the filtered view for the entire list of
contacts. In Word, I've tried to add the start, end, location fields to the
merge template under Insert Merge Fields but they aren't there to insert.

My question is, how do I "link" the appointment fields with the contact
fields in the data source that Word is looking at?

Any help with the above would be appreciated.

Thanks,

Art

 

[Sue Mosher [MVP-Outlook]]

The only way to accomplish what you want to do is to write a custom application. Outlook can only merge data in the contacts folder. The calendar data is all in a separate folder that can't be included in a merge.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Artemus]

Sue, thanks for your reply. Can the MS Office Managment Edition 2006 do what
I want it to do?

Also, If I know someone with very good VB skills, would they be able to
write something that "hooks up with" the Oulook API or do I need an MVP to do
that?

Just curious,

Artemus

 

[Sue Mosher [MVP-Outlook]]

Can the MS Office Managment Edition 2006 do what

I want it to do?

That product just provides a new SKU that adds Small Business Accounting to Office Pro. It has no new functionality related to putting calendar data into a mail merge.

Also, If I know someone with very good VB skills, would they be able to
write something that "hooks up with" the Oulook API or do I need an MVP to do
that?

Someone with good VB skills and a healthy amount of curiousity should be able to handle the OUtlook API.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers