Macro does not display maro in outlook correctly

[Howardc1001]

I have the following macro which attaches a specific sheet in outlook

When the message appears in the body it appears as :

Hi Mark

Regards

Howard


It is this part of the code that I am battling to get right, so the body of the message appears correctly

Please Login or Register  to view this content.

It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[rorya]

Is this part actually two lines? (it shouldn't be)

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek


I used your code, but nothing appears now in the body of my email using Outlook

I have tried to see what is causing this buy cannot figure it out


Please check and advise

[Howardc1001]

Hi Rory

It should be one line

[rorya]

What do you see if you add a message:

Please Login or Register  to view this content.

[sintek]

The above snippet of code is outside of the With outmail statement and this part inside With statement

Please Login or Register  to view this content.

I also see you did not declare strBody...Ensure that your code always has Option Explicit on top....

[Howardc1001]

Hi Sintek

I have have amended code per your input and still get nothing in the body of outlook
Option Explicit

Please Login or Register  to view this content.

Please check & advise what is possibly causing this

[sintek]

Upload your sample file...Also what result does Rory's suggestion in post 6 give...Is the value blank

This works...

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek


I have uploaded my Sample file as I cannot get message to display in the body. Rory's code displays displays a blank value

Please Login or Register  to view this content.

[rorya]

You haven't attached a workbook, but that code creates two emails. The first has the body you specify but is never displayed.

I suggest that you remove the On Error Resume Next line and try the code again.

[sintek]

I have uploaded my Sample file

Where?...

Strange both the codes in post 9 work as they should...

Howard...Your code in Post above does not have the required snippet...in the With Outmail statement

Please Login or Register  to view this content.

[Howardc1001]

When I removed "on error resume Next" , I get a run time error-"subscript out of range and the code below is highlighted

Please Login or Register  to view this content.

Please check & advise

[rorya]

One of your sheet names is wrong then.

This is why you shouldn't just stick On Error Resume Next into a routine for no purpose...

[sintek]

When I removed "on error resume Next" , I get a run time error-"subscript out of range and the code below is highlighted

that is because the newly saved book is active...

I am very certain this code can be tidied up...
But anyway...

Please Login or Register  to view this content.

THIS IS HOW I WOULD DO IT....

Please Login or Register  to view this content.

[Howardc1001]

Thanks Sintek for all the help & your input


Code works perfectly now

[sintek]

Coolio...Glad you got it sorted...