Hi everyone, I'm new to this site and I'm hoping someone can either help me or tell me i'm wasting my time.

My objective is a hopeful one at least. I work in an office and we recently agreed to send a list of outstanding invoices to multiple parties each month.

I currently have a spreadsheet which lists outstanding invoices which is grouped into their relevant handler and then each account subtotalled. I have ammended the sheet so the lists can be autofiltered to show everything I need. The data includes the email address which the data will be sent to along with other information.

Is there a way I can use this data to create some kind of macro or script to take the group of data then create and send an email with the data shown when i filter the handlers name to the email address included in the spreadsheet instead of sending 427 emails at the beginning of each month?

Hopefully this is something which will be very simple once everything is set up. My company uses Windows XP and Excel 2003 :S

Thank you very much in advance
Stephen

Hi Stephen,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]