Access.2007.VBA.Bibl..

Microsoft Access (continued)

ExportAppointmentsToOutlookfunction,

241–243

ExportContactsToExcelfunction, 191–195

ExportFlatFileContactsToOutlook

procedure, 255–258

exporting appointment data to Outlook,

241–243

exporting contact data to Outlook, 255–258

exporting data to Excel, 184–187

exporting data to Outlook items, 220–233

exporting data to unformatted Excel worksheets,

50–52

exporting data to Word documents, 135–138

exporting data to Word using Automation code,

138–182

exporting mainframe data as Outlook Journal

items, 79–81

exporting queries to Excel, 184–187

exporting task data to Outlook, 247–249

exporting tasks and appointments to Outlook,

72–78

ExportTasksToOutlookfunction, 247–249

filling Word documents with Access data by

using TypeTextmethod, 27–30

Help overview, 272–277

history of data transfer techniques, 4

ImportApptsFromOutlookfunction, 243–245

ImportContactsFromOutlookfunction,

259–262

importing Outlook appointment data from,

243–245

importing Outlook contacts to, 259–262

ImportTasksFromOutlookfunction, 250–251

Layout view, 134–135

methods for merging data to Word, 145–182

new templates in Access 2007, 230–233

Object Browser, 94

placing indicators in Word templates where data

should appear, 30–45

preparing databases for upsizing to SQL Server,

629–631

SQL Server Migration Assistant, 671–672

storing data, 4

transferring timesheet data to Excel, 211–218

using to enter and edit data, 4

Word Mail Merge feature, 136, 138

Word (RTF) feature, 136, 137

working with attachments, 391–396

working with older format databases in Access

2007, 91–96

Microsoft Database Engine (MSDE), 629, 631

Microsoft Excel

CreateExcelTimesheetsfunction, 211,

212–218

creating new documents based on WSH scripts,

614, 615–616

creating PivotCharts from Access queries,

415–426

ExportContactsToExcelfunction, 191–195

exporting Access data to, 184–187

exporting Access data to unformatted

worksheets, 50–52

importing queries from Access, 415–416

Object Browser, 94

opening XML files, 346–347

transferring Access timesheet date to, 211–218

TransferToExcelfunction, 186

using templates to create formatted worksheets

filled with data, 52–62

workbooks versus worksheets, 183

Microsoft Office

Access version issues, 263–264

adding .NET support to, 559–573

changing installation in Windows Vista,

560–562

Custom UI Editor, 518–519

customization deficiency, 520–521

customizing user interface, 520

FileDialogobject, 263, 264–270

history of data transfer techniques, 3–4

installing based on Windows version, 560–562

version issues, 627

M Index

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