can u email single field

[Dave Smith]

can u email a single field, ie a memo (it will be like a newsletter)

i have a query that finds the field & a report to email, but when emailed it
emails the entire set of records (fields)

i have a button on the form over the query that sends the information

thanks in advance

Dave Smith

 

[Joseph Meehan]

can u email a single field, ie a memo (it will be like a newsletter)

i have a query that finds the field & a report to email, but when
emailed it emails the entire set of records (fields)

i have a button on the form over the query that sends the information

thanks in advance

Dave Smith

The answer to your question is yes. However I am not sure of exactly
what you want to do.

First lets makes sure we are speaking the same language.

A field is one segment of a record. A record may have fields called
FirstName, MiddleInitial and LastName. Sending one field would be like
sending just the FirstName.

A table has many records. So sending FirstName could mean sending
everyone's first name or just one individual's first name.

Sending a record would be sending the information in all the fields for
one record.

A database may have many tables, some with the same names for fields.

So exactly what do you want to send A single field of one record. all the
fields for one record, a single field from all the records?

You indicate that you have a button on the form over the query that
sends the information; I'm sorry but I have no idea what this is. Do you
mean a form based on a query?

Part of a potential problem is it appears you did not design the
database so we don't know what might be going on and a suggestion might not
work or might conflict with the programming of your database. Normally I
might suggest changing the query to provide the information you want to
send, but I am just not sure.

 

[Dave Smith]

ok, so sorry for the confusing language...

i want to send one field from one table, in my case it will be a memo field.
it will be from a table which will have a "newsletterID" field & a "memo"
field. i want to select ONE "memo" field from the "newsletter" table & email
it. which is kinda why i have a (yes u are quite right to criticise)"form
based on a query" at the moment (i only THINK i need to do this)
and um.. yes i have designed this database.. its my first can you tell? haha

and thank you very much for taking the time with my query

Dave Smith

 

[Joseph Meehan]

ok, so sorry for the confusing language...

i want to send one field from one table, in my case it will be a memo
field. it will be from a table which will have a "newsletterID" field
& a "memo" field. i want to select ONE "memo" field from the
"newsletter" table & email it. which is kinda why i have a (yes u are
quite right to criticise)

Only a problem because I was not sure what you were doing. Access has a
lot of unique language and it takes a while to even start knowing it.

"form based on a query" at the moment (i
only THINK i need to do this)
and um.. yes i have designed this database.. its my first can you
tell? haha

and thank you very much for taking the time with my query

Dave Smith

Well there is a way to send it directly (or at least indirectly) from
Access, but I have never used that feature (little need and for my
professional life I did not have access to Outlook as a mail program and I
am not sure you can do it without Outlook or using Lotus Notes.). I would
just use a copy and past.