Word / Excel 2000 Mail Merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo - 23 Feb 2007 19:26 GMT

I need to create a 15-page Word document to send to 100 individuals. Once
this document has been created I would then like to merge tables and graphs
from Excel. These tables and graphs are member-specific and there will be a
approximately 200 tables and 300 graphs (some individuals will receive a
report that has 3 tables and 1 graph and some individuals will receive a
report that has 4 tables and 3 graphs, etc). Can I achieve this?

If so, what would be the best way to manage the data? Would it be best to
hold each individual’s chart / graphs on their own sheet in Excel?

I believe this data is to be inserted on different pages throughout the
report.

I would appreciate any advice regarding the above.

Jo

Reply to this Message

Doug Robbins - Word MVP - 23 Feb 2007 20:54 GMT

That sounds like a pretty ambitious project.

One thing that you should look at is the Mail Merge to a Chart item on
fellow MVP Cindy Meister's website at:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Where is the data at the moment?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I need to create a 15-page Word document to send to 100 individuals. Once
> this document has been created I would then like to merge tables and
[quoted text clipped - 14 lines]
>
> Jo

Reply to this Message

Jo - 24 Feb 2007 01:12 GMT

Thanks for your response.

Well, having read your link I'm still unsure if I'm trying to achieve the
impossible. Way above anything I've ever done before.

The project is still at planning stage, although I have seen samples of the
type of chart / graphs to be merged. It's more a case of trying to find a
starting point and finding the best way forward and if it's achievable.

Do you think the desired result can be achieved?

Jo

>That sounds like a pretty ambitious project.
>
[quoted text clipped - 10 lines]
>>
>> Jo

Reply to this Message

Doug Robbins - Word MVP - 24 Feb 2007 06:37 GMT

It can probably be achieved, but whether it can be done with Mail Merge is a
bit doubtful. More likely a "roll-your-own" type application using Visual
Basic. It depends a bit on data source.

Mail merge can only use a single, flat file as a data source so having an
Excel sheet for each individual is not going to work.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thanks for your response.
>
[quoted text clipped - 24 lines]
>>>
>>> Jo

Reply to this Message

Jo - 26 Feb 2007 21:15 GMT

Again, thanks for your reply. Looks like plenty of cutting and pasting for me
then.

Jo

>It can probably be achieved, but whether it can be done with Mail Merge is a
>bit doubtful. More likely a "roll-your-own" type application using Visual
[quoted text clipped - 8 lines]
>>>>
>>>> Jo

Reply to this Message

Jo - 06 Mar 2007 22:45 GMT

Could you please expand a little more to your response "roll-your-own" type...
...

We've decided not to put in graphs, but still need to merge all data to the
documents. There are currently 60 fields (all data prepared in Excel) and
each individual (approximately 100 ) is to receive a report showing their
personal information, ie: 60 x 100.

Now we've decided not to put in the graphs is it possible to achieve this
part of the task?

Jo

>It can probably be achieved, but whether it can be done with Mail Merge is a
>bit doubtful. More likely a "roll-your-own" type application using Visual
[quoted text clipped - 8 lines]
>>>>
>>>> Jo

Reply to this Message

Doug Robbins - Word MVP - 07 Mar 2007 20:28 GMT

To get a better idea of what you need to do, can you send me a copy of what
would be the mail merge main documnet and possibly a "dummy" result
document.

Send it to dkr[at]mvps.org

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Could you please expand a little more to your response "roll-your-own"
> type...
[quoted text clipped - 24 lines]
>>>>>
>>>>> Jo

Reply to this Message