General discussion


Auto email message containing attachment

By Rabs ·
I have a schedule which creates a .csv file which I wish to email to a set person on a daily basis. We are using Outlook 2000 as email clients and Exchange 5.5 as the server. The file comes from Cognos Impromptu - where there doesn't seem to be a function to send an exported file using it's scripting language. Do I need to develop some VB code to do this - if so I'll need to learn VB quick. Please help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Auto email message containing attachment

by Glenda Gable In reply to Auto email message contai ...

Check out the Microsoft Knowledge Base ( ==> Support ==> Knowledge Base)

Check out Article # Q161088

This article shows you how to Automate the sending of an Email Message. It also has the code needed to perform this procedure.

If this is coming from a particular PC or workstation, you should be able to save this as a Macro within Outlook (using VBA) and just set a menu item or toolbar button to automatically do it for you.

It also shows you how to attach a file as well as address the email to a particular person or persons.

If you are sending this email message from multiple workstations, either install this macro onto all workstations or put it on the server somehow. This is a little less familiar to me, but I know it can be done (it IS friday afterall).

Either email me or send a comment if you need more help.

Related Discussions

Related Forums