Analyze with Excel

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a query with data I want to export to Excel and then email to a
recipient as an order form. I want to have a header on the spreadsheet which
includes common information as might appear in a form such as Order Date,
Ordered By, Shipping Method, etc. Then I want the body of the spreadsheet to
contain information which would commonly appear in a subform. This would be
information such as Item Number, Description, Quantity, etc.
Question is, how do I create the header and populate it with the appropriate
information. Do I create an Excel template and use code to attach the
appropriate information to header fields, and if so please explain how to do
this.

Ivor
 
Ivor,

You may wish to consider an alternative method of doing
this.

Why not create a form and corresponding tables to hold
the order information and an invoice/order confirmation
report to email to your customer. Add a button to the
order form that will email the report to your customer.

While there very well may be a good business reason to
export the information out of Access, populate a form,
and then email it off, it seems labor intensive, when it
can be done straight from Access itself.

Mark
 
Mark...

I wanted to convert to Excel because I'm sending the information half way
around the world and want to have the recipient fill in some information and
return it to me. If I send an Access report, I won't have this capability.
Please correct me if I'm wrong.

Ivor
 
Ivor,

You are correct that you can not manipulate a report if
sent that way. And that would certainly be a good
business reason to create the Excel file.

It's been a long time since I've done anything like this,
but what you could do, is create your order form in
Excel, and using the options main menu, Data/Import
External Data, you could create a few queries and QRY
files, but then you could import the records to your form.

It is do able, but I haven't done anything like it in so
long, I wouldn't want to try and provide additional help
that takes you down a wrong path. I suggest asking how
in the Excel newsgroup or looking in Excel help.

Good luck

Mark
 
Back
Top