Email to Lotus Notes

Bianchi928
Bianchi928 used Ask the Experts™
on
I need to be able to email users their phone bills to their respective email in Lotus Notes

The attachment script zzz.vbs reads an input xls file and generate a list of output file for each phone user.
Next, I need to email this file to the email account in Lotus Notes which is

eg  Julia PetersenPhoneBill.dat will be sent to julia_petersen@?????.com

Can the attached export info.vbs be modified

Thanks
Cheers
zzz.vbs
test.xls
Export-Info.vbs
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi

You could try to open the servers addressbook and do a lookup for each username to get the email address back.
I found a solution for it.
SendPhoneBill.vbs

Author

Commented:
Did the trick for me

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial