Exporting Into PowerPoint

[Zippyfrog]

I am not sure where to post this, so I am trying the general forum. What I have right now is a very simple access database for teachers at our school to use - it has a field for who the announcement is from, who the announcement is for, the announcement, and the date the announcement is for.

What I want to do is export each record from Access and put each record on a separate PowerPoint slide, where the title of the slide is who the announcement is from, and the body of the slide contains the announcement. Is there any way to do this easily? I have tried the MSDN thing where you create a form that brings up an instance of PowerPoint, but I would really like to do an export of records from Access then import them into PowerPoint. Any suggestions on how to do that?

(here is the link from MSDN http://msdn2.microsoft.com/en-us/library/aa159920(office.11).aspx, this isn't what I want to do - I want a separate ppt file)

 

[Peter Reid]

The MSDN example is almost there

If you don't want the slideshow to run, remove the line;

ppPres.SlideShowSettings.Run

If you want to save the presentation, add a line along the lines of;

ppPres.SaveAs "c:\YourFileName.ppt", ppSaveAsPresentation