Access.2007.VBA.Bibl..

Microsoft Outlook

activating Journal component, 80

Application object, 234–235, 236

built-in contact ID fields, 359

comparing contact data with Access contact

data, 359–390

CopyAccessAttsToOutlookprocedure,

391–392

CopyAccessContactsToOutlookprocedure,

390

CopyAllOutlookContactsToAccess

procedure, 390

CopyOutlookAttsToAccessprocedure,

392–393

CreateProjectApptsfunction, 245–247

CreateProjectTasksfunction, 253–254

ExportAppointmentsToOutlookfunction,

241–243

ExportFlatFileContactsToOutlook

function, 255–258

exporting Access task and appointment data to,

72–78

exporting appointment data to Access, 243–245

exporting changing Access data to, 220–233

exporting task data to Access, 250–251

ExportTasksToOutlookfunction, 247–249

ImportApptsFromOutlookfunction, 243–245

ImportContactsFromOutlookfunction,

259–262

importing appointment data from Access,

241–243

importing mainframe data as Journal items,

79–81

import/link folder selections, 222–223

ImportOutlookContactsfunction, 361–365,

390

ImportTasksFromOutlookfunction, 250–251

linking Access tables to, 221–229

linking Calendar folder to Access tables, 224

linking Contacts folder to Access tables,

224–225

linking Tasks folder to Access tables, 223–224

Object Browser, 94

referencing items in VBA code, 240–241

refreshing contact data, 361–374

syntax for referencing objects, 235–240

working with appointments, 241–247

working with attachments, 391–396

working with contacts, 254–262

working with tasks, 247–254

Microsoft Script Editor (MSE), 592–597

Microsoft Scripting Runtime Library, 263, 271

Microsoft Windows Script, 271. See alsoWindows

Script Host (WSH)

Microsoft Word

creating blank documents by using Automation

code, 27–28

creating fancy shipping labels, 397–415

creating new, blank documents based on default

template, 140–141

creating new, blank documents based on

selected template, 141–143

creating new, blank documents by using

NewDocfunction, 140–141

creating new, blank documents by using

NewDocFromTemplatefunction,

142–143

creating new documents based on WSH scripts,

614–615

Document Information Panel, 148

file format differences, 31, 146

filling documents with Access data by using

TypeTextmethod, 27–30

importing Access data, 135–138

importing Access data using Automation code,

138–182

methods for merging Access data to, 145–182

Object Browser, 94, 139

opening by using CreateObjectfunction, 39,

44–45

sending letters to multiple Access contacts,

158–165

Index M

25_047026 bindex.qxp 4/2/07 9:58 PM Page 687