Emails with a Macro

[srcacuser]

Hello,
I currently have a Macro called by a "save/email" button. This macro will email (EmailDatabaseObject) the current form out to several users as a .pdf. In design view of this macro, there were only a few items available.
Object Type, Object Name, Output Format, Subject, Message Text, etc.



Is it possible somehow to modify this macro to include the current record number or another field? So the email recipients wouldn't have to open up the .pdf? For example, the message text of the
email would include "09012A0000". Or, the .pdf attachment would be the name of the record? It seems code would be involved, if this is possible at all.

Thanks in advance

[pbaldy]

I would use code, but you can try something like this in the macro:

"Your message text " & Forms!FormName.TextboxName & " more text here"

[srcacuser]

Thans for replying Paul.
Where do I do this? In the design view, it doesn't appear to take code in the lines.?

[pbaldy]

I just did a brief test and it doesn't appear that the macro will resolve the form reference. If you switch to VBA code, you can definitely do it there:

DoCmd.SendObject , , , "blah@test.com", , , "subject", "test " & Forms!form1.Text16 & " whatever", True

If you're not sure where to place VBA code:

http://www.baldyweb.com/FirstVBA.htm

[srcacuser]

There is an option to "convert to Macro", and that gives me a VB window. But none of the code that's added will then save to that macro. It reverts back to the former.

[pbaldy]

Converting the macro was a one way trip.

You want to use VBA instead of the macro to do what you're trying to do. It doesn't appear that the macro can resolve the form reference in the message.