D
Derek Wittman
Good morning,
I'm trying to do a SendObject macro, but the email message
text is too long for the space provided. I can't even
copy/paste into it without getting an error message.
So, I'd like to do the same function in VBA, but I'm
totally new to VBA. I don't even know where to begin. I
see the syntax in the help file:
DoCmd.SendObject [objecttype][, objectname][, outputformat]
[, to][, cc][, bcc][, subject][, messagetext][,
editmessage][, templatefile]
but I'm sure I need code before and after. I would like
to run this code from a macro (RunCode) but am currently
getting an error message. If my module has a name with
spaces, do I need quotes surrounding the module name?
Also, I have a bunch of stuff in the VBA folders box that
is foreign to me.
Can someone please help?
Derek
I'm trying to do a SendObject macro, but the email message
text is too long for the space provided. I can't even
copy/paste into it without getting an error message.
So, I'd like to do the same function in VBA, but I'm
totally new to VBA. I don't even know where to begin. I
see the syntax in the help file:
DoCmd.SendObject [objecttype][, objectname][, outputformat]
[, to][, cc][, bcc][, subject][, messagetext][,
editmessage][, templatefile]
but I'm sure I need code before and after. I would like
to run this code from a macro (RunCode) but am currently
getting an error message. If my module has a name with
spaces, do I need quotes surrounding the module name?
Also, I have a bunch of stuff in the VBA folders box that
is foreign to me.
Can someone please help?
Derek