Mail Merge in Powerpoint

S

StatMan

We have a huge project that we do every quarter. We do approximately
1000 slides (one each for 1000 dealers) that each contain a bar chart
and some text. Is there any way to do a "mail-merge type" setup in
Powerpoint so that we can create the chart once and have Powerpoint
automatically create a slide for each record in an Excel spreadsheet?

Thanks,
Brian
 
S

StatMan

Steve said:
Man's got religion, I see. <g>

Unfortunately, Merge won't merge data into charts. Yet.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Any idea if there's a way to do this or not?
 
B

Brian Reilly, MVP

Brian, Oh, you are another Brian!
Sure this is possible. I do this sort of thing all the time. Just
don't think of MailMerge as the concept.

How comfortable are you with VBA coding?

Before I'd offer any advice, I would first ask you how the data is
arranged. Excel right? Want to post a few (two or three) rows of XL
data for each dealer/record (change the data as you see fit for
confidentiality. I just need to see a spreadsheet layout, assuming you
are using spreadsheets to maintain the data.

Brian Reilly, MVP
 
S

Sethu V

Hi,
I had a similar problem and discovered a dead simple solution. Here are the steps.

1. In the ppt choose "Edit > Select All" (You can skip header/footer if not required) and Copy (Ctrl C)

2. Open a new word file and go to "File > Page setup" and choose "Landscape" layout mode (it is best for ppt slides)

3. Go to the Drawing tool bar and (if it is not visible, go to "Toolbar - Drawing". In the Drawing tool bar, click any shape (say circle). On clicking, an outline rectangular box will open up in the word document page. (Dont worry about the circle created, you can delete it later, it is just to invoke the "rectangular drawing area box"

4. Rt click your mouse in the drawing area (now shown as outlined rectangle), and just paste the ppt certificate content that you had copied in Step 1 above

5. The ppt slide content is now visible inside the drawing box. You can edit the content just by simple mouse click. At this point you have fully "editable" ppt content within a word document in landscape mode

From hereon, you can follow the standard Word Mail merge procedure (Tools > Letters and Mailings > Mail Merge > Letters (or email) and create do a regular mail merge using data sources (xl data, CSV, txt file etc).

After setting up the mail merge, simply send it as e-mail (or) "print to pdf" (or) Print to file.

Using the above method, I printed out 450 certificates which contained 4 fields that were merged from an xl sheet (Student Name, Project Name, Scores, Certificate #)

Try it out and I am sure it will solve your problem!!

No need for any add-ons or extra s/w, just MS office functionality is good enough to get this done!!

Cheers!!

Sethu V
eXample Consulting Group
http://www.eXampleCG.com
(Enabling Excellence!!)
 
L

LVTravel

Geez what a moron!~ Posting to dead egghead posts from 1 and 3 years ago.
Don't these morons ever look before they type? Just the kind of person that
is representing "Enabling Excellence!!,", yea, right!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top