PDA

View Full Version : Solved: Vba Automate Emailer for Lotus 6.5.3



khalid79m
06-30-2010, 03:02 PM
Hi

Info
code for excel 2003; and lotus 6.5.3

Files attached
Main File: OutboundEmailer.xls
Folder: Daily Logs - Do Not Delete -> Daily logs are created and kept here as a txt files by the main file

Description
I have created a template using excel; once the user has filled it in the template and selects the submit button the required data is copied on to a temporary file which then is attached to an email via outlook before deleting the temporary file. Also a log of the person whom has made the submission is kept on a txt file.

Issues
I need two versions of this file; The first version I have created myself and it works with Outlook... the other version which I require needs to be identical but to work for lotus 6.5.3..... The issue I am having is writing the code for the version which works on lotus.

I would appreciate any assistance.

Additional Info

In module 3 Ln 24 you will need to added your userid fOSUserName is you wish to access admin section but not really required

In Module 6; you will find Sub Test which will unprotect all sheets etc ….