I am analyzing a query with excel. In excel, I have created a template that
is linked to the query. I want to email that template on to others, but
they are getting messages, unable to find source - unable to update link,
etc. They can ignore errors and receive the worksheet without errors.

Is there a way to send info from access to email users while retaining the
format and having some fields protected? Then, they can enter info into
unprotected fields and email back to me.

Any suggestions?

Thanks in advance,
JR

You probably want to make the query a dead copy of the data rather than
saving the query definition.

Put the cursor in the query output table and Data / Import External
Data / Data Range Properties ... uncheck Save Query Definition.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Could you be more specific as to how I accomplish this? Thank you.

"Bill Manville" wrote in message
...
You probably want to make the query a dead copy of the data rather than
saving the query definition.

Put the cursor in the query output table and Data / Import External
Data / Data Range Properties ... uncheck Save Query Definition.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

I don't know how to be more specific than to say again:

Put the cursor in the query output table and Data / Import External
Data / Data Range Properties ... uncheck Save Query Definition.


I am assuming that you are using Excel 2002 or later (it always helps
if you say which version) and that the data was brought in from Access
by Data / Import External Data / New database query.

If this is not the case then you will have to help me by giving me more
information about what you did.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill - I just realized that you and I had communicated previously regarding
this situation. I was unable to import data from access because I get to
the point where excel ask if I want to view with MSQuery, (2 other
questions) and a box to check if I want to save query. I did not check Save
Query (did not see exact phrase - save query definition) and I get error
that it was looking for parameters. The query has parameters in access and
it works without problems in access. I do not know what to do about
parameters once I get to the importing procedure from access to excel.

Excel 2002 version

Thanks
"Bill Manville" wrote in message
...
I don't know how to be more specific than to say again:

Put the cursor in the query output table and Data / Import External
Data / Data Range Properties ... uncheck Save Query Definition.


I am assuming that you are using Excel 2002 or later (it always helps
if you say which version) and that the data was brought in from Access
by Data / Import External Data / New database query.

If this is not the case then you will have to help me by giving me more
information about what you did.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

We may be misunderstanding each other a bit.
Let's start again.

Jwr wrote:
I am analyzing a query with excel. In excel, I have created a template that
is linked to the query

How is it "linked"?
From your latest message it seems it might not be by the usual Data / Import
External Data / New Database Query mechanism that I had been assuming.

If you have somehow created a DDE link to the results of the Access query (and
I admit I didn't know that was possible) then you may be able to kill the link
by Edit / Links / Break Link.
If not, try Edit / Copy; Edit / Paste Special / Values.

The query has parameters in access and
it works without problems in access. I do not know what to do about
parameters once I get to the importing procedure from access to excel.

I haven't tried importing from an Access query with parameters.
I know how to create an MSQuery query with parameters.
At the end of the query wizard, elect to view the query with MS Query.
Display the conditions grid.
Enter the field name in the top row of the conditions grid.
Enter a prompt like [Which City?] in the second row.
Execute the query - you should be prompted for the parameter.
In that way you could change the Access query not to have parameters and
supply the parameters at the MSQuery stage.
Back in Excel there are options to get the parameter value from a cell and
even to refresh the query when the cell value changes.

I did not check Save
Query (did not see exact phrase - save query definition)

If you mean the Save Query... button on the last part of the query wizard,
that is a different type of save, I think. It saves the query in a text file.

When you get back to Excel you get a dialog headed Import Data asking where
you want to put the results. On this dialog if you click Parameters you can
tell it where to get the parameter value from, and if you click Properties you
will see the dialog in which you might later uncheck the Save Query Definition
box to make the query non-refreshable.

Are we getting closer?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup