I am trying to learn about Access 2007 macros. I downloaded the Call Tracker
template from Microsoft.com. The Call Details form in this template has an
E-mail button which, when clicked, dumps the contents of the form’s
Description field into the body of the e-mail. The E-mail button runs an
embedded macro On Click. Looking at the properties of the embedded macro’s
SendObject action, the Message Text action argument looks like this:
=IIf([Form].[Description].[TextFormat]=1,PlainText([Description]),[Description])
I want to include the form’s Comments field in the Message Text too, so
that the email message will include the Comments field contents followed by
the Description field contents (if possible I would like these on separate
lines). Can anyone point me in the right direction to do this? Thank you.

Rgille,

Without looking at the actual template you are using for your example, I
guess it is likely to be like this...

=IIf([Form].[Description].[TextFormat]=1,PlainText([Comments] & Chr(13) &
Chr(10) & [Description]),[Comments] & Chr(13) & Chr(10) & [Description])

--
Steve Schapel, Microsoft Access MVP


"rgille" <(E-Mail Removed)> wrote in message
news:25483594-49F8-4A96-8A27-(E-Mail Removed)...
> I am trying to learn about Access 2007 macros. I downloaded the Call
> Tracker
> template from Microsoft.com. The Call Details form in this template has
> an
> E-mail button which, when clicked, dumps the contents of the form’s
> Description field into the body of the e-mail. The E-mail button runs an
> embedded macro On Click. Looking at the properties of the embedded macro’s
> SendObject action, the Message Text action argument looks like this:
> =IIf([Form].[Description].[TextFormat]=1,PlainText([Description]),[Description])
> I want to include the form’s Comments field in the Message Text too, so
> that the email message will include the Comments field contents followed
> by
> the Description field contents (if possible I would like these on separate
> lines). Can anyone point me in the right direction to do this? Thank
> you.

Steve - Thank you, that worked! One question: Is there way to automatically
insert a "carriage return" (blank line) between the Comments text and the
Description text in the generated e-mail? Thanks again. - Bob

"Steve Schapel" wrote:

> Rgille,
>
> Without looking at the actual template you are using for your example, I
> guess it is likely to be like this...
>
> =IIf([Form].[Description].[TextFormat]=1,PlainText([Comments] & Chr(13) &
> Chr(10) & [Description]),[Comments] & Chr(13) & Chr(10) & [Description])
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "rgille" <(E-Mail Removed)> wrote in message
> news:25483594-49F8-4A96-8A27-(E-Mail Removed)...
> > I am trying to learn about Access 2007 macros. I downloaded the Call
> > Tracker
> > template from Microsoft.com. The Call Details form in this template has
> > an
> > E-mail button which, when clicked, dumps the contents of the form’s
> > Description field into the body of the e-mail. The E-mail button runs an
> > embedded macro On Click. Looking at the properties of the embedded macro’s
> > SendObject action, the Message Text action argument looks like this:
> > =IIf([Form].[Description].[TextFormat]=1,PlainText([Description]),[Description])
> > I want to include the form’s Comments field in the Message Text too, so
> > that the email message will include the Comments field contents followed
> > by
> > the Description field contents (if possible I would like these on separate
> > lines). Can anyone point me in the right direction to do this? Thank
> > you.
>
>

Rgille,

Chr(13) & Chr(10) takes you to a new line. To insert a blank line, just
repeat...

[Comments] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [Description]

--
Steve Schapel, Microsoft Access MVP


"rgille" <(E-Mail Removed)> wrote in message
news:644C5F43-AB76-4E77-B503-(E-Mail Removed)...
> Steve - Thank you, that worked! One question: Is there way to
> automatically
> insert a "carriage return" (blank line) between the Comments text and the
> Description text in the generated e-mail? Thanks again. - Bob
>

Many thanks Steve. - Bob

"Steve Schapel" wrote:

> Rgille,
>
> Chr(13) & Chr(10) takes you to a new line. To insert a blank line, just
> repeat...
>
> [Comments] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [Description]
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "rgille" <(E-Mail Removed)> wrote in message
> news:644C5F43-AB76-4E77-B503-(E-Mail Removed)...
> > Steve - Thank you, that worked! One question: Is there way to
> > automatically
> > insert a "carriage return" (blank line) between the Comments text and the
> > Description text in the generated e-mail? Thanks again. - Bob
> >
>
>
>

If you wanted to lable these feilds in the email how would you do so?

"Steve Schapel" wrote:

> Rgille,
>
> Chr(13) & Chr(10) takes you to a new line. To insert a blank line, just
> repeat...
>
> [Comments] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [Description]
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "rgille" <(E-Mail Removed)> wrote in message
> news:644C5F43-AB76-4E77-B503-(E-Mail Removed)...
> > Steve - Thank you, that worked! One question: Is there way to
> > automatically
> > insert a "carriage return" (blank line) between the Comments text and the
> > Description text in the generated e-mail? Thanks again. - Bob
> >
>
>
>

I am not sure what you mean, Matt. Can you give an example of what you
want?

--
Steve Schapel, Microsoft Access MVP


"matt" <(E-Mail Removed)> wrote in message
news:A3DC45F8-3A2C-48F4-8339-(E-Mail Removed)...
> If you wanted to lable these feilds in the email how would you do so?
>

Hi Steve,
I found this thread very useful. Firstly, thanks for your help.

Now, just in addition to this: I would like to add free text.

I want to add comments and due date, but i would like to add free text in
the email which says "Comments" and "Due date" as headings.

Could you please help me with this?

Thanks

"Steve Schapel" wrote:

> I am not sure what you mean, Matt. Can you give an example of what you
> want?
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "matt" <(E-Mail Removed)> wrote in message
> news:A3DC45F8-3A2C-48F4-8339-(E-Mail Removed)...
> > If you wanted to lable these feilds in the email how would you do so?
> >
>
>
> .
>

[coop301]

I too found this very helpful and I as well, need a little bit of guidance. In the expression: > =IIf([Form].[Description].[TextFormat]=1,PlainText([Comments] & Chr(13) &
Chr(10) & [Description]),[Comments] & Chr(13) & Chr(10) & [Description]),

I would like to add data from a table before the comments and description are inserted. The table name is "Atext" . The column name is "Phrase". the ID is 1

can you point me in the correct direction?