Breaking down a list and sending it to individuals

[chevell]

I now have a database with user names and file names attached to them with the location, size and date last accessed. Each users has several entries in their name. I want to be able to send a single email to every user in the database listing all the files in their name. The email itself is no problem. How do I calculate the list of files and only send them one email? Thanks!

[chevell]

Ok, I've even managed to create a report that has the list sorted and grouped by user. I basically just need to find a way to convert the report into a script and send the individual lists of files to the individual users.

Does any one have any ideas? i'm out of them. Thanks!

[chevell]

Here's a screen shot of the report...

[sbg2]

What about exporting the list of files and including as an attachment?

Otherwise you could:

- Create a self-join relationship where UserName = Username

- Create a Text Calculation field = "File: " & FileName & ", " & "Location: " & Location .... etc.

- Create a Value List based on the Text Calculation field above using only related values from the first table occurence.

- In the Body field of the Send Mail dialog specify: ValueListItems ( "MyFileNameHere" ;"MyValueListHere" )

[chevell]

My first problem is getting a list of files that belong to each individual username. For example, Joe Shmoe has 5 files, with the following names and the following sizes totaling this much size. Right now, i just have a report that says that, but I can't get a script to do anything with it. Nor have I been able to figure out how to export data in a grouped format.

[sbg2]

Enter Find Mode

Set Field[userName; "Joe Shmoe"]

Perform Find

Export Records

[chevell]

Obviously, I can do it for each individual user. We're talking about several hundred if not thousands of users. I need a way to script it all. Thanks!

[sbg2]

come on now, you can figure this out.

short version:

Loop

-perform find[MyEmailFlag = 0]

-Set Field [g_UserName; UserName]

-perform find[userName = g_UserName]

-Export Records

-send mail and attach file

---Loop

---Set Field [MyEmailFlag = 1]

---go to next record; exit after last

---End Loop

End Loop

[chevell]

Ok, that will work, thanks for the obvious logic I couldn't quite grasp! Now if I can just get the valuelistitems to work I'll be set! If I set a field to be a popup list with that value list, its valid. If try to insert it into the message body, it doesn't work. Almost there! Thanks in advance.