Mail merge individual spreadsheets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

claudlarue - 21 Jul 2005 20:50 GMT

I have an Excel workbook with 40 or so individual sheets pertaining to
different departments in our corporate group. Each month I print these
sheets and fax them to the respective departments. Is there a way I could
email these sheets using mail merge? Perhaps as an object attachment? The
information on these spreadsheets is confidential so I only want those sheets
that apply to a particular department sent to that particular department.

Reply to this Message

Doug Robbins - 21 Jul 2005 22:12 GMT

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

But you are going to need separate Excel files if you want to selectively
send the data.

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 have an Excel workbook with 40 or so individual sheets pertaining to
> different departments in our corporate group. Each month I print these
[quoted text clipped - 3 lines]
> sheets
> that apply to a particular department sent to that particular department.

Reply to this Message

claudlarue - 22 Jul 2005 21:33 GMT

Thanks for the response. I had been hoping I wouldn't have to save the
sheets as separate files. Do you know if there is a macro that would allow
me to do this all at once without saving each sheet one by one?

> See the article "Mail Merge to E-mail with Attachments" at
>
[quoted text clipped - 10 lines]
> > sheets
> > that apply to a particular department sent to that particular department.

Reply to this Message

Anne Troy - 22 Jul 2005 21:41 GMT

Claud: That would take a bit of programming, and since it's Excel
worksheets, you'd be better off asking in the Excel programming group, I
think. :)
*******************
~Anne Troy

www.OfficeArticles.com

> Thanks for the response. I had been hoping I wouldn't have to save the
> sheets as separate files. Do you know if there is a macro that would allow
[quoted text clipped - 14 lines]
> > > sheets
> > > that apply to a particular department sent to that particular department.

Reply to this Message

larrynospam@nospamjbmsystems.com - 22 Jul 2005 21:47 GMT

Hi,

There are software packages (such as my OctoTools) that can help do this,
but unless you have some significant volume, the cost is only justified if
you really, really really (three of 'em) want to do this.

Larry T.

Reply to this Message

claudlarue - 25 Jul 2005 13:27 GMT

Thanks for the feedback. It will be easier doing going through this process
each month knowing there really isn't an easier way (unless I scrounge up an
intern).

Claudia

> Hi,
>
[quoted text clipped - 3 lines]
>
> Larry T.

Reply to this Message