Report Export Problem

[Crispy]

Morning all, please can anyone help with a little problem?

I have a report which I need to export into either Word or Excel to email to a range of recipients. The problems I have are:

If I export into Excel, the memo field in the report is curtailed to 255 characters.

If I export into Word, all the data is there but I can't format it the way I need - i.e. display it as a table.

I can't use Snapshot Viewer or Acrobat to distribute the report as it needs to be editable by the users.

Any possible solutions would be gratefully appreciated.

 

[richary]

You say the report is to be emailed. Could it be emailed directly from Access using Docmd.SendObject?

 

[Crispy]

No, because it's part of a larger report I produce. Anyway, using SendObject doesn't solve the problems re formatting (Word) or data loss (Excel)

Thanks anyway for replying.

 

[Hayley Baxter]

I posted a link in this thread.

Thread

If you follow the link and download the sample you will see that there is some code used to enable you to take the report from Access to word and still keep it in the same format as it appears in Access.

You will obviously have to amend the code to match you field names etc but you should be able to use it to get you started.

Hay