Merging & attaching email -->file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
Have 28 employees, each with a monthly productivity report in an Excel spreadsheet. The spreadsheets are individual by employee name and sent out each month, but all are kept in a single folder on my desktop PC.

Have created a distribution list of the 28 employees but cannot find a way to attach 'spreadsheet john doe' to 'email john doe', so the distribution/merge, so far, is not workable for me.

Any way to automate this process even a bit? Very tedious...address one email, attach one spreadsheet, and send. Continue on for 27 more.

Thanks !
 
How good are you with VBA in Excel ?
The way this is 'normally' done is via a VBA procedure (macro) in Excel
You set up a list of e-mail addresses in a workshet, then simply get the macro to save each persons sheet in a separate workbook, which is then auto-e-mailed to then through Outlook - so Excel completely drives Outlook
I have an example which I can send you - but you'll need to have a knowledge of Excel VBA to adapt it to your needs

Regard

Martin
 
Back
Top