Attach multiple documents using tsendmail

[Anonymous]

Hi

All,I have a query which will pull in some physical paths which is present in a database table. Along with that I need to replace the filename as well.

Let say for eg:-The path is/data/media/10000234.csvThe original name of the file is hello.csv. I need to replace this 10000234 with hello.

Secondly there can be additional paths which would be pulled in from the query and they would have some different filenames.So, in this scenario I would like to get all the files which may be present in various locations replaced with their filenames and attach to a single email.Please suggest

[Anonymous]

Hi

[Anonymous]

All,I have a query which will pull in some physical paths which is present in a database table. Along with that I need to replace the filename as well.

[Anonymous]

Let say for eg:-The path is/data/media/10000234.csvThe original name of the file is hello.csv. I need to replace this 10000234 with hello.

[Anonymous]

Secondly there can be additional paths which would be pulled in from the query and they would have some different filenames.So, in this scenario I would like to get all the files which may be present in various locations replaced with their filenames and attach to a single email.Please suggest

[TRF]

Use tFileCopy to copy or move files from the source folder to a temporary folder.

With the same component, you can change the target file name as desired.

Using tSendMail, you will attach the temporary folder to the email, not the individual files.

Finally, delete the temporary folder.