Im a novice at this but here is what Im trying to accomplish. My
office has hundreds of memos going out on a regular basis. All of
these memos go to a set group of people from a set group of people.
Those people change based on the sender and recipient. The body of the
memos is based on a set number of subjects. I have most of this
automated now but the problem is that in VBA using the Select Case
Method I have told access what to show for the body based on the
subject but the body contains information that needs to be a field from
a query. How do I reference that field? For example a memo to a car
dealer about new cars would have a set body, part of which is the
contact information from the person sending it. So the body would be
something like this:
Dear Mr. [Owner of Dealer]
My office is interested in purchasing 3 new vehicles from your
dealership. When you have time to discuss specifics please contact
Purchasing Officer [PO] at [Phone Number].
Sincerely,
[PO]
Keep in mind that the body of this memo needs to be calculated as well
based on the subject the user selects. I hope this makes sense. My
job has nothing to do with cars but I cant comment on what I do so the
example probably confuses things. Thanks in advance for any help you
can provide!
Rob