Mail Merge without Word

[Adam Bailey]

Hello,

I have a form in an Excel document and a list of people in another. I need
to do a mail merge from the list into the form. There's no Data Merge
Manager in Excel.

Is there a way to do this?

Thanks!

-Adam

--
Adam Bailey | Chicago, Illinois
ad...@lull.org | Finger/Web for PGP & S/MIME
ada...@aol.com | http://www.lull.org/adam

[Adam Bailey]

Hello,

I have a form in an Excel document and a list of people in another. I need
to do a mail merge from the list into the form. There's no Data Merge
Manager in Excel.

Is there a way to do this? I'm getting around the problem by pasting the
Excel document into Word, but it seems like there should be a better way.

Using Office 2004.

[Jim Gordon MVP]

Hi Adam,

There are two approaches to solving this problem. Michael has pointed
out the productivity "get it done" solution, which is to use Word's data
merge manager to accomplish the merge.

However, if you are looking for some learning excercises you could
create a Macro in Excel to cycle through your list and use an
appropriate function such as vlookup or index. This approach would take
considerably more time and effort than copying your form to Word, but
would result in greater knowledge of Excel.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

[JE McGimpsey]

In article <slrncu5emi...@millennium.akb.lull.org>,
Adam Bailey <ad...@lull.org> wrote:

> Hello,
>
> I have a form in an Excel document and a list of people in another. I need
> to do a mail merge from the list into the form. There's no Data Merge
> Manager in Excel.
>
> Is there a way to do this? I'm getting around the problem by pasting the
> Excel document into Word, but it seems like there should be a better way.
>

There's no built-in way to do a data merge the way you do in Word.

I can think of a couple of ways to approach the problem in XL, but they
involve using VBA macros. Post back if you're interested in going that
route.