M

macro recorder, 202 Mail Merge method advantages and disadvantages, 146 for documents, 176-182 for lists, 176

for mailing labels, 175-176 MailMergeTextFile procedure, 177, 178-182

as method for merging Access data to Word, 146,175-182 mailing addresses code for updating in Access, 385-387 creating shipping labels in Word, 397-415 labels for Mail Merge, 175-176 synchronizing, 353-354 as user information field, 31, 32, 33 MailMerge object, 139, 140 MailMergeTextFile procedure, 177, 178-182 make-table queries, 109, 201, 205, 352 Manage Data Tasks screen, 310-311 MAPIFolder object, 235 .mda file format, 472, 473 .mdf file format, 656 Memo data type, 5 Memo field, Access creating, 5-6 storing data in, 5-6 versus Word DocProperty field, 10

menu add-ins, 478, 549-560 merge fields, 10

Merge It With Microsoft Office Word option, 135 MergeBookmarks procedure, 165-169 MergeData.txt file, 177, 180 MergeDocProps procedure, 160, 161-164 MergeTypeText procedure, 170-175 merging Access data to Word bookmarks method, 145, 165-169 comparison of methods, 145-146 document properties method, 145, 146-165 Mail Merge, 146, 175-182 TypeText method, 146, 170-175 message class, 240-241 Microsoft Access backing up databases, 277-282 calendar pop-up, 52, 53, 320 comparing add-ins with COM add-ins, 469 comparing contact data with Outlook contact data, 359-390 concatenating data for export, 143-144 CopyAccessAttsToAccess procedure, 394-395

CopyAccessAttsToOutlook procedure,

391-392

CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390 CopyOutlookAttsToAccess procedure,

392-393

CreateProjectAppts procedure, 245-247 CreateProjectTasks procedure, 253-254 creating client/server applications, 657-662 creating databases from templates, 225-229 creating denormalized tables from linked tables,

352-359 creating e-mails from tables, 81-85 creating form letter reports, 8-10 creating worksheet-type reports, 11-25 DAO support, 90, 91-96 ExportAccountSummary function, 195-200

Microsoft Access (continued)

ExportAppointmentsToOutlook function, 241-243

ExportContactsToExcel function, 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

ExportTasksToOutlook function, 247-249 filling Word documents with Access data by using TypeText method, 27-30 Help overview, 272-277 history of data transfer techniques, 4 ImportApptsFromOutlook function, 243-245 ImportContactsFromOutlook function, 259-262

importing Outlook appointment data from, 243-245

importing Outlook contacts to, 259-262 ImportTasksFromOutlook function, 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

CreateExcelTimesheets function, 211, 212-218

creating new documents based on WSH scripts,

614,615-616 creating PivotCharts from Access queries, 415-426

ExportContactsToExcel function, 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 TransferToExcel function, 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 FileDialog object, 263, 264-270 history of data transfer techniques, 3-4 installing based on Windows version, 560-562 version issues, 627

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 CopyAccessAttsToOutlook procedure,

391-392

CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390 CopyOutlookAttsToAccess procedure,

392-393

CreateProjectAppts function, 245-247 CreateProjectTasks function, 253-254 ExportAppointmentsToOutlook function, 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 ExportTasksToOutlook function, 247-249 ImportApptsFromOutlook function, 243-245 ImportContactsFromOutlook function, 259-262

importing appointment data from Access, 241-243

importing mainframe data as Journal items, 79-81

import/link folder selections, 222-223 ImportOutlookContacts function, 361-365, 390

ImportTasksFromOutlook function, 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 also Windows

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

NewDoc function, 140-141 creating new, blank documents by using NewDocFromTemplate function, 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

TypeText method, 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 CreateObject function, 39, 44-45

sending letters to multiple Access contacts, 158-165

Microsoft Word (continued)

sending letters to single Access contacts, 150-158

setting User Templates folder path, 604-605 setting Workgroup Templates folder path,

604-605 user information fields, 31-33 using templates for creating formatted documents, 30-45 version issues, 146 Modified Northwind.accdb sample database, 11 MSDE (Microsoft Database Engine), 629, 631 MSE (Microsoft Script Editor), 592-597

0 0

Post a comment