Access to Excel

[SteveE]

How can I send via email an access report to Excel without loosing the formatting.

Is it possible to setup and specifya formated template to send the data into? then email user who need this report don,t have access and dont,t need it, but will give a lot of agraviation if the reports are not in the "normal" format.

 

[sambo]

Unfortunately your report will lose some of its formatting when you transfer it over to Excel.

You can, however, create an Excel template and transfer data over through code. This is a very complicated process, I'm afraid.
But if you are still interested tranfering over to a template you can take look at the method used in this post. I've used a method similar to this and it works fine. Only bad thing, it takes a lot of time and VBA knowledge to develop.

 

[SteveE]

ok thanks, its a bit beyond me at this time, but maybe in the future.

 

[neileg]

You can do it in Word, and you keep the formatting (well mostly anyway). If your recipient wants to extract the data into Excel, this is obviously possible from Word.

You could also use html format. I've not used this myself, but there are lots of options here and most of the formatting is preserved.