Sending MORE than one workbook AND using .CC and .BCC as well?

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Using XL'03, using Ron's tips, I have successfully sent one workbook,
or sheet or range but I would like to send more than one workbook.

I have used VBA to put the files in a folder and zip and send them,
but I do not wish to zip them.

How can I d this and how can I also use the e.g. .To and .CC .BCC as
well.


Many thanks.

Simon
 
If you are using outlook, just loop through all files adding each as a
separate file, just as the zip is added, and also set the .cc and ,bcc
properties as you to with the .To property.

HTH

Bob
 
Back
Top