Access table to excel template to mail

[absgrind]

Does anyone have an example to take an access table, input it to an excel
template, save it as a workbook, then ship it out as an email attachment to a
specific customer?

I have the inventory table, the excel template, and the email address stored
in a customer table.

Boss wants paperless office - send inventory spreedsheet to a customer, have
them update priorities, then ship back to us.

 

[Piet Linden]

Does anyone have an example to take an access table, input it to an excel
template, save it as a workbook, then ship it out as an email attachment to a
specific customer?

I have the inventory table, the excel template, and the email address stored
in a customer table.

Boss wants paperless office - send inventory spreedsheet to a customer, have
them update priorities, then ship back to us.

Transfer records to Excel using automation:
http://www.mvps.org/access/modules/mdl0035.htm

Save it as a workbook... that's just a simple Save... surely that
can't be terribly hard.

Ship it as an e-mail attachment... if you're using Outlook, sample
automations are like rash around here. Search one of the relevant NGs.