Email A Worksheet (read It!)

Hi everyone!

I know the solution for this is given in the solutions. But my problem is bit diffrerent.
I have a gui It contains following components.

1. Select Worksheet to email(All he sheets comes in a listbox we can select any on of it.)

2. Select recipeient to whom u want to mail (I am getting the list from outlook contacts, But i am getting it in this form---- lastname,firstname----)


3.Enter message for the body


4. Enter subject

5. Send worksheet



Now i want to send the selected worksheet to the recipient in the textbox,In text box i dont have his/her email id so i have to take it from outlook by matching the name and lastname.

can u give me the solution

what doesnt work? are you getting errors?
is it not sending?

Moved to Office Development Forum. ;)

These files are in vb6 I think. Can't say for sure, but I cannot open them in Visual Studio.Net 2003, and I never used VB6 before.

This issue has been cross posted on other forums as well with no resolution because the project cannot be opened to check out what it going on.

#1) This line here:

VB Code:

ActiveSheet.Cells.Copy ' copy the contents of the ActiveSheet

Where is this coming from? The code above appears to instantiate Outlook, but then all of a sudden you are trying to copy the cells from an Excel file somewhere, but I don't know if you even have an Excel workbook open because the code that this is running in (guessing here) doesn't seem to be in an Excel file.

This issue needs resolved, is there an Excel workbook open when you press this button?

i have not used activesheets.cell.copy

i have replaced all the ocurrences of activesheet by Sheets(List1)

project is not opening or what?

No, I am not able to open the project you submitted here.

What are you using to build this project?

VB6 or Excel?

If you dont have VB6 you can open the files using notepad, except for the .frx file and possible the .ctl file too. ;)

its developed using vb 6 (activx control)
also need excel 200 or 2002 or 2003

shall i attach it once again?