Mailing different files to multiple persons

[pedrofogao21]

Hi,

I am using Ron de Bruin's code to mail different files to multiple persons. The code can be found here:

http://www.rondebruin.nl/mail/folder2/files.htm

In column C I should write the address of the file I want to send. I am using the same workbook, which I edit in several different ways and save them in different folders. I want to send each edited file to each address in column B.

My question is: how can I update the content of the cells in column C automatically with the new file that was just saved? As I want to do this on a daily basis, it would be very helpful if this process was automated.

Thanks!

[Chippy]

My question is: how can I update the content of the cells in column C automatically with the new file that was just saved?

Run something like this after each saving of the workbook:

Please Login or Register  to view this content.

That's the general idea. Only you know which rows in column C (and up to column Z, as per Ron's code) need to be populated with the file name.

[pedrofogao21]

Thanks for you help. The thing is, I am using SaveCopyAs, since I want to continue to work on the original Workbook as I run the macro, so I don't think I can use the command Range("C1").Value = ThisWorkbook.FullName

[Chippy]

SaveCopyAs requires a file name to be specified, so just store that in the C column. Maybe something like this:

Please Login or Register  to view this content.

[pedrofogao21]

Thanks a lot Chippy, it is working fine now.