send Email MSAccess2016

[fishhead]

Is there a way to create a macro that will open an outlook email and populate the TO, SUBJECT and MESSAGE fields without having to use the EMailDatabaseObject?
i don't want to attach an object type or format etc to the email i only want to populate these 3 fields. Currently i'm using the EmailDatabaseObject macro but it ask for what type of file i wish to attach (and i don't want to attach anything?)

thanks,

[pbaldy]

I don't have 2016 on this machine, but isn't there a "Send no object" option? Or won't leaving the object type and name arguments blank worked? I don't use macros but just tested in 2010 and leaving them blank doesn't prompt for them.

[ranman256]

docmd.SendTo ....

[pbaldy]

docmd.SendTo ....

Is that something new?

[fishhead]

sorry but i don't understand what to do with "docmd.SendTo..."
please explain

[Micron]

I have 2016 version but rarely use macros. Created one to test this - it does not ask me for an object name or type to send. Perhaps you have something in the 'name' property field, or have selected an object type without specifying a name? Outlook was already open, but I don't think that would make any difference to the behaviour you're describing.

It's a very limited method for sending emails, and I had to deal with the Outlook security 5 second warning and delay, which is another reason why not many of us here would use a macro for sending email.

[fishhead]

thanks, are you using the EMailDatabaseObject command to create the email? If not what is the macro command you used?

[Micron]

I would say 'yes'...


Ignore that I replaced my email address with asterisks********

[fishhead]

Here's what mine looks like...

it is returning the following options:


i am trying to just send the email without any attachment

[Micron]

I added form references like yours and still no prompt beyond the security message. I even tried adding a few blank spaces to the object name option to see if it would ask for the object type but no difference.
Not being big on macros, all I can think of is to convert the process to code or start over; the macro might be corrupt.

[pbaldy]

What happens if you change the edit message argument to Yes?

[Micron]

Me? Nothing except that Outlook opens a message window so it can be edited. Otherwise it just sends it.

[pbaldy]

Me? Nothing except that Outlook opens a message window so it can be edited. Otherwise it just sends it.

No, fishhead. I got no prompts either, just taking shots in the dark.

[fishhead]

No, fishhead. I got no prompts either, just taking shots in the dark.

I get the same results - works fine just let's user edit the message

[pbaldy]

By works fine does that mean no prompts for file type?