EMAIL to a group of user listed in the excel report

I successfully created a excel report, which has a column of email address of the users listed in the report.
There is a need to send everyone listed using the email address in report an email from time to time. Since the list may be changed everyday and there will be at least 100+ users listed.

I am able to add a hyperlink in the excel report so I can click and send them a message one by one. However, any one has any idea how I can add/have only one link in report so I can click on and everyone in the report will be added in the email address line.
The purpose is to send ONE email to everyone on the report. I am doing that in a WWW self service page, and we are using OUTLOOK.
Thanks for helping

Prod: WebFOCUS 7.1.1 CGI - Self Service - Report Caster,Win2000/IIS
Output: HTML, Excel 2000 and PDF

Posts: 36 | Location: LOS ANGELES | Registered: February 01, 2006

susannah

Expert

posted

Hide Post

make a custom address list in the contacts section of outlook
and then caster can use that listname.
change that list whenever you need to.
its quite simple to do.
or..
let caster make a dynamic list , assuming you are creating this list using a fex that happens to output to excel.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

FrankDutch

Virtuoso

posted

Hide Post

Supposed you have a database where the burst value and the email address is in you can do this:

TABLE FILE USERS
PRINT
USERCODE AS 'BURSTVALUE'
EMAILADRESS AS 'MAILADRESS'
WHERE ....
ON TABLE HOLD FORMAT PCHOLD
END

You should lookup the for the exact ASNAMES somewhere, since I'm not sure about these fields.
It creates an xml file.

In the reportcaster process setup you choose this fex as dynamic file.

Frank

BTW If you do a "find" on this site you will find a lot of helpfull tips on this issue.

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7