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