Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending MORE than one workbook AND using .CC and .BCC as well?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending MORE than one workbook AND using .CC and .BCC as well?
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 "Simon" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending MORE than one workbook AND using .CC and .BCC as well?
Hi Simon
See my Outlook examples and also click on the tip link that you see on each example page http://www.rondebruin.nl/sendmail.htm You can repeat this line for each file you want to add or create a loop ..Attachments.Add ("C:\test.txt") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Simon" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a variable to another workbook? | Excel Programming | |||
Sending Workbook | Excel Programming | |||
Sending sheets in workbook | Excel Discussion (Misc queries) | |||
sending only one sheet from a workbook | Excel Programming | |||
Sending data to a different workbook | Excel Programming |