TekSavee2k

Is it possible to use 1 variable document to populate a Word, excel & PowerPoint document - using Microsoft Office 2007? Should the variable document be created in Word, Excel or Access?

fumei

Could you explain more?

TekSavee2k

the simpliest example is a merge document with variables being merged into a word document with merge fields. Can you use the same document to merge with excel and powerpoint? Has anyone done that before, say in a marketing environment when you would have various documents going out to a huge mailing list, and these documents might be composed in word, excel and powerpoint - is it possible to use one variable document to merge the details into the entire mailshot (composed of ms office documents) and would this variable document have to be access, excel or word?

I hope this is clearer.

fumei

Yes, it is possible.

TekSavee2k

Are you going to tell me how?

fumei

Not without you giving your exact requirements. How could I? You asked a general question - is it possible to have a document that gathered information from other Office applications:

" Can you use the same document to merge with excel and powerpoint? "

And the general answer is - again - yes, it is possible. Basically, you:

1. design and set up the template that will hold the information,
2. make instances of the other applications,
3. use those instances to gather the information,
4. put that information into the appropriate places in your template.

So if you were doing it in Word, you would:

- design the places that will hold the information you are going to get, and these could be fields, bookmarks, formfields - hard to say without knowing what you are doing exactly...

- create an instance of Excel (for example)

- use that instance of Excel to open an Excel file, get information/data from that file, and put that data/information into the places you have designed for it to go into.