Mail Merge in Powerpoint

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StatMan - 28 Nov 2007 16:46 GMT

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

Reply to this Message

John Wilson - 28 Nov 2007 17:08 GMT

I've never tried this but I'd be VERY surprized if it wasn't good.

http://www.pptools.com/merge/index.html

Signature

Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> 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
[quoted text clipped - 4 lines]
> Thanks,
> Brian

Reply to this Message

StatMan - 28 Nov 2007 17:21 GMT

> I've never tried this but I'd be VERY surprized if it wasn't good.
>
> http://www.pptools.com/merge/index.html

I looked at this, but I think it only allows you to merge text. What
I'm looking for is the ability to merge data into a chart.

Reply to this Message

Steve Rindsberg - 28 Nov 2007 19:12 GMT

> I've never tried this but I'd be VERY surprized if it wasn't good.
>
> http://www.pptools.com/merge/index.html

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
================================================

Reply to this Message

StatMan - 28 Nov 2007 19:28 GMT

>>I've never tried this but I'd be VERY surprized if it wasn't good.
>>
[quoted text clipped - 9 lines]
> PPTools: www.pptools.com
> ================================================

Any idea if there's a way to do this or not?

Reply to this Message

Steve Rindsberg - 29 Nov 2007 05:15 GMT

> >>I've never tried this but I'd be VERY surprized if it wasn't good.
> >>
[quoted text clipped - 11 lines]
> >
> Any idea if there's a way to do this or not?

Not with anything I've done, no.
Let's see what Brian's got in mind.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

Brian Reilly, MVP - 28 Nov 2007 21:11 GMT

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

>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
[quoted text clipped - 4 lines]
>Thanks,
>Brian

Reply to this Message

Rate this thread: