Send long message in email object. (2007)

[mutley1]

Hi all,

I have a message that is probably about 500 words long and am using the Run Macro on a button then SendObject. I get the warning that the message is too long when I copy and paste it into message box in the create macro screen.

Is there an easy way to do this without VBA etc., i.e. just use simple macro stuff. I have tried having the long message as a memo in a table then a query to pull the message but it goes as an attachment of whatever you select. I want to get it in the actual message itself as text without VBA (unless anyone has VERY SIMPLE CODE but would rather avoid that.

Thanks,

M.

 

[kjv1611]

I would definitely do this with VBA if it were me, but since you don't want to do that, what about this... Is there a way to do send 2 different pieces of text to the message, one after the other, so that one is part1 of the body, and the other is part2?

It may not be possible, but it's just a thought. I've not used macros very often, particularly since I began using VBA. Once you see just how much you can do with VBA, macros (in my opinion) are practically useless.

And the nice part about VBA is that for basic, simple stuff, you don't have to be any sort of programming wiz anyway. Oftentimes, what you CAN do is right in front of you... you start typing DoCmd. and as soon as you put the dot/period there, you see a list of what you can do... just for instance.

And for something common like sending emails, there are TONS of already preprogrammed scripts on the web you can copy/paste to your project, and then most of them also offer detailed instructions as to what's going on, as well as how to change it to fit your needs..

Anyhow, see if my little macro deal works.. if not, it may require VBA.

The only other thing I could suggest would be (if possible) reduce the length of the body text. So, if it's not in table form, but rather paragraph, there are probably ways to reduce the length.

--

"If to err is human, then I must be some kind of human!" -Me

 

[mutley1]

Thanks K,

I'll have a play around.