Copy specific cells as text into body of a new OUTLOOK message

Hello all: I have used this amazing forum before and had great success and I have been looking hard for this answer and found some code that doesn't quite work and I am sure you smarty-pants out there can help.

I have a excel 2010 and our company uses OUTLOOK (I believe Office 365) as it's email service.

I am trying to have a command button at the bottom of the attached form to basically copy cells A1:O85 to the body of an email as plain text.

If I have done this right, the file should be attached.

Can someone help me with the code?

Thanks,

Hi,

I can do no better than point you to Ron de Bruin's ever helpful web pages on this subject.

See http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

Okay, the first code seemed to work, This one:

Please Login or Register  to view this content.

But this is a form that uses drop down lists that depending on the data in the cell (Selected by this drop down list) will hide fields no longer needed. As soon as the first drop down list removes (hides) some rows, the command button still opens an email, but there is no data. As long as the you fill in other fields and click the command button it works fine but as soon as some rows are auto-hidden, no data is copied to the body of the email.

Thoughts?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

And are you now changing your original requirement, which was as I understood it to replicate exactly all of A1:O85 in the body of an email.

Originally Posted by guido0136

I think I got the issue. There were merged cells ....

...ahhh, the dreaded words. A word of general advice. Most of us avoid merged cells like the plague. They are just too troublesome and you can almost guarantee that sooner or later they will trip you up. If you're lucky they'll trip up and something will crash so that you know something untoward has happened. If you're unlucky then you might just get wrong results and never know. Avoid them. The most common use of merged cells is simply to position a value midway across a range of cells. In which case the format 'Centre (OK Center if you're the wrong side of the pond ) across Selection' is to be preferred.