Mail merge excel into Visio

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Santiago - 03 Aug 2004 20:30 GMT

(If this is not the right Newsgroup, can you show me
where I should post this question?)
How can I merge a Visio document with an Excel database?
It would be an Org Chart where I would enter mergefields
into each box.

Reply to this Message

Peter Jamieson - 03 Aug 2004 21:21 GMT

As far as I know, there is no built-in way to do a mailmerge where the
equivalent of a "mail merge main document" is a Visio document. However, you
might be able to use VBA to "roll your own" merge in Visio. Unfortunately
a.I'm not that up-to-date with Visio
b. this is not the right group - I suggest you try one of the visio groups-
not sure which are current but the following pop up in my list:
microsoft.public.visio
microsoft.public.visio.general
microsoft.public.visio.developer
microsoft.public.visio.developer.vba

(I'd probably start with the last of those and see what response I got).

Signature

Peter Jamieson

> (If this is not the right Newsgroup, can you show me
> where I should post this question?)
> How can I merge a Visio document with an Excel database?
> It would be an Org Chart where I would enter mergefields
> into each box.

Reply to this Message

Cindy - 05 Aug 2004 21:46 GMT

>-----Original Message-----
>(If this is not the right Newsgroup, can you show me
[quoted text clipped - 4 lines]
>.
>I'm not a Visio superuser, but I have created charts by

using the org chart wizard in Visio and then
inserting/mapping the excel fields in the wizard. It's
important to make sure that each person on the org chart
has a supervisor and that the top level supervisor has
blank for his/her supervisor. This wizard might only be
availalbe with 2003 though.

Reply to this Message

Rate this thread: