Form Question

[Guest]

I have a form that i use. The only part of the form that changes when I send
it out is a Name in the body of the email. Can I automatically replace this
name with the new name in one step ? Sort of a find and replace ? can it be
done witrh a vba macro ? regards.

thank you in advance.

 

[John Vinson]

I have a form that i use. The only part of the form that changes when I send
it out is a Name in the body of the email. Can I automatically replace this
name with the new name in one step ? Sort of a find and replace ? can it be
done witrh a vba macro ? regards.

thank you in advance.

Is this a "form" in the business sense - i.e. a page of text? or a
Form in the Access context - a data entry/editing screen? How are you
sending the email?

If you're sending an Email from an Access database, then yes, it's
easy to have a Report based on a query; the report could have
"boilerplate" text for the constant portion of the message, with a
Name field coming from the table.

If you're not using Microsoft Access, please repost your message (with
some clarification, perhaps) in a more appropriate newsgroup.

John W. Vinson[MVP]