Attached workbooks

[amal1973]

I have 66 Excel workbooks. Every workbook is saved as a department number (ie: 0021985.xls). I would like to send every workbook to its specified department (Department Manager). I have a list in an access database that has the department number and the manager name and email …….

How can I attach every workbook with the right email …

Please advice

Ps.. i have the workbooks created and in a folder .

 

[xlbo]

Depends which email system your company uses
There's a whole bunch of code in the archives here to automate emails

Rgds
~Geoff~

 

[amal1973]

I am using MicrosoftOutlook .....
but how can i say that if the workbook name is "12321.xls" send it to the this email ?

 

[kylua]

You can obtain the email address by:

emailadd = left(activeworkbook.name, len(activeworkbook.name)-4) + "@mydomain.com"

Then run the mailing code with that emailadd where the email address goes.