VBA - Lotus Notes

Good Afternoon,

I have a macro that creates an email using Lotus Notes.

The problem is that instead of attaching the Excel file it puts the path to where the find the file.

Can you please help me?

Please Login or Register  to view this content.

Originally Posted by Norie

Why is stAttachment in quotes here?

Please Login or Register  to view this content.

That will make VBA read it as the literal string 'stAttachment' not whatever is in the variable stAttachment.

Well that was a mistake

Thanks for noticing.

Still it doesnt solves the main issue here.

Thank you.

Originally Posted by Norie

Actually I've misread the code, though it is confusing.

I think "stAttachment" is being used here to create a rich text object named 'stAttachment'.

Please Login or Register  to view this content.

By the way, where are you setting/getting the value for fich2?

fich2 is a excel file that's created before this code runs.

Please Login or Register  to view this content.

First thing i checked was that.It gives the file path to the correct excel. I'm lost because i have another file where i can get the attachment to the email...