Pasting Range into Emial body as PDF

[bdouglas1011]

ON one of my sheets I have a macro that pastes a certain range of cells on clipboard then you open outlook and paste it into the body.

The problem is formats sometimes gets lost and others change the info after it is pasted.

Sub Covercopypaste()
Range("b1:h46").Select
Selection.Copy

End Sub


What I would like it to do:

Once you click the button it copies the sheet and converts into PDF then pastes it into the body of an email

The recipient should be reports@sharewell.com
They can add the subject line them selves

This is all to start with and once this works I can go from there

[Solus Rankin]

pdf is a file type. Try this:

Please Login or Register  to view this content.

[bdouglas1011]

Is it possible to change into PDF before it Pastes into Outlook that way people cannot edit the email body that gets pasted for the excel sheet.

[Solus Rankin]

You can attach it as a pdf. pdf is a filetype so you can only create a file. The body of an email is either written in simple text or in html. It doesn't have its own filetype.

You can set the macro to send the email automatically instead of displaying it. This will prevent them from being able to edit it.

[gkumthekar]

I have no idea wht RangetoHTML function is but it is working fine for me... thanks to whoever wrote it!!!!

[Solus Rankin]

It changes the range you would like to email into HTML (Hyper Text Markup Language) which is a format the Outlook recognizes for the body of it's emails.

[gkumthekar]

Hi Solus,

I have a question again about RangetoHTML...

Does this function not work if you have an email to work upon through Reply All?

The function works fine if I am creating a new email. I have another macro through which I found an email based on the subject, then replied all and tried to use RangetoHTML to paste the range from Excel sheet in that email...

THe code RangetoHTML appears to work fine until the very end but then gives an error at the last but one line ( Just before End Function!) but nothing is written in the email....


Any idea about this behavior? Can you help me with this strange problem?

Thanks in advance!

Regards,
Ganesh K

[Solus Rankin]

@gkumthekar

Please start a new thread with an appropriate thread title and describe your issue.