Script to email report layout

[JMart]

Hi gurus,

 

I have a flat database what contains username, phone ext, department, and email address. I created a layout report grouped by department. I would like to create a script that sends the layout to each user using the email on the database.

 

Can someone guide me or point me to a sample script.

 

Thanks

JMart 

[Lee Smith]

Take a look at Menu »» File »» Send

The Script Step is found in the Script Workspace as a step , it will give you the same form as in the Send Mail, found under the File »» Send.

Here is the link to the Help online for Send Mail

[Lee Smith]

I just noticed that some of the files in your Template folder, that came with your application, have an example of the Send Mail script. here the one in Assets.com

Set Error Capture [ On ]
If [ not IsEmpty ( Assets::Selected File Container )  and $$PLATFORM ≠ "Web" ] 
	Set Variable [ $PATH ; Value: Get ( TemporaryPath ) & Assets::Selected File Container ] 
	Export Field Contents [ Assets::Selected File Container ; “$PATH” ] 
End If
Send Mail [ Send via E-mail Client ; With dialog: On ; Subject: "Asset: " & Assets::Item & If ( not IsEmpty ( Assets::Category ) ; " [" & Assets::Category & "]" ; "" ) ; Message: If ( not IsEmpty ( Assets::Item ) ; "Item: " & Assets::Item  & ¶  ; "" ) & If ( not IsEmpty ( Assets::Category ) ; "Category: " & Assets::Category  & ¶ ; "" ) & If ( not IsEmpty ( Assets::Model ) ; "Model: " & Assets::Model  & ¶ ; "" ) & If ( not IsEm…" ; “$PATH” ] 

That you can use as an example.

Lee