March 22, 2007, 01:48 PM
DKWANEMAIL 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
March 22, 2007, 02:16 PM
susannahmake 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.
March 22, 2007, 03:16 PM
FrankDutchSupposed 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.
April 03, 2007, 11:47 AM
DKWANI tested out both Susanna and Frank's method and both work for me. Thanks.