Excel Macro lotus notes email Select range and paste in subject

Good afternoon,

A quick question.
Im quite new to VBA and was trying to figure out how to do it by myself but I can't seem to get it to work.

The problem is I'm trying to select a filtered range in column C to be entered as subject in a lotus email.
When column D has a value One, Two or Three. In column C only the data matched to One should be selected and pasted as Subject.

If it's not possible the body of the email would be fine to but it would be really great if we could have it in the subject.
I can select just one cell

Please Login or Register  to view this content.

But when I try to select the whole column I get an error code.

Please Login or Register  to view this content.

Am I doing something wrong??
Could someone help me resolve this issue????

The full code below:

Please Login or Register  to view this content.

Maybe:

Try changing this

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

Hi John,

thanks for your reply.

When I change the VBA code to:

Please Login or Register  to view this content.

It does work but I can't seem to select the whole column.

Please Login or Register  to view this content.

I've never been able to select a whole column for a subject line. How many rows does your Column C contain.

Originally Posted by JOHN H. DAVIS

I've never been able to select a whole column for a subject line. How many rows does your Column C contain.

Hi John,

It varies from 1 to 10 rows.

If it's not possible to add to whole column would it be possible to add the column to the body of the email??

You could use something like this for either:

Please Login or Register  to view this content.

There may be better ways, but this is the only way I know.

Hi John,

It would be a solution.

Do you have any idea how I can add the column to the body of the email??
Or would I encounter the same problem???

The only way I know would be similar to the solution for the subject. Someone else may have a better idea.

Originally Posted by JOHN H. DAVIS

The only way I know would be similar to the solution for the subject. Someone else may have a better idea.

Thanks for your help John...

You're welcome. Glad to help out, sorry I couldn't offer a better solution.