How to link excel elements to powerpoint presentations?
mark area or object in the Excel file to be linked to a powerpoint presentation
select slide in the presentation
PPT menu bar
Home -> Paste -> Paste special -> Paste link
How to update a linked object?
click with right mouse on the object
choose update link in the menu
What are the technical preconditions to use the “presentation marker”?
installation of the excel camera
installation of the microsoft powerpoint library in Excel
How to install the excel camera?
Quick Access Toolbar -> More commands
-> all commands
-> click on camera
How to install the MS powerpoint library?
shortcut Alt + F11
Tools -> References
References VBA project
activate -> Microsoft PowerPoint # Object Library
What is important for the input mask for the presentation maker?
path to excel file
name of the worksheet
area in the worksheet to be copied
distance from left margin and top margin
Zoom
Title
How to send mail merge?
mailings -> start mail merge (letter, email, envelope, labels)
select recipients (new list, existing list, outlook contacts)
insert merge fields
finish and merge
MS Outlook -> work offline
check and send
What is important for the lists of mail merge?
excel file with headers that becomes merge fields
address needs to be there
Last changed2 years ago