Field pre-populate in email

G

Guest

Hello,

I had asked this question before but was unable to get complete.

On my form when I click the Send Email button, the email pops up before
going out. I would like for a certain field (GLNumber) to pre populate in the
email as it shows on that record. Then of course, if you are on a different
record with a different GLNumber have the email pre populate with that number
and so on.

Can this even be accomplished? If not, I can just have the user manually
input in the email before sending. Please clarify and simplify answer as I am
a novice with Access.

Thanks!!
 
B

BruceM

Are you using SendObject to send the e-mail? If so, just add [GLNumber] to
the appropriate place in SendObject. If [GLNumber] is to appear in the
message body, then just add [GLNumber] after the seventh comma following
SendObject. If it is to appear in the subject line, place it after the
sixth comma. You need to use commas as placeholders, even if that means you
will have several commas in a row. See Help for more about SendObject.
If this does not help, post the code behind the Send Email button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top