Discussion Locked

Auto email message containing attachment

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.
Thanks

1 reply

by glenda gable

Check out the Microsoft Knowledge Base (www.microsoft.com ==> 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.

This discussion is closed to new replies.