export to excel and schedule mailing

[#1]

hello everyone..i need to send automatic mail of document using macro.

bt my requirement is i want to send north report to north person and south report to south person similarily for east and west.

can anybody pls help me with this.

[daveamz · Accepted solution]

Hello Monica,

The file attached use macro to export a qv char report into excel and then send it on email.

Unfortunately I can't write some documentation right now but I will try to answer to your questions as soon as possible.

If you unrar the files, change the SMTPServer ( just the IP), Email Sender in the macro and 'QWREmail' field in the script this file should work.

Because of the macro script doesn't display any error message is pretty hard to debug it.

Best regards,

David

[#3]

Thanx a lot David..it worked for me too..cheers