Importing to Word

[J Colligan]

Although reports look really sexy in access, most of my audience prefer to review them online via E-Mail. The challenge has been making the reports "MicroSoft Word Friendly", more specifically importing and hoping the formatting is not so absurd, attaching to an e-mail is possible. (pdf is too hard for these dinosaurs!)

I would really like to know if someone has figured out what the import assumptions are that drive the behavior of access, especially the mysterious way it treats memo fields!

Thank in advance,

joe (jncolligan@statestreet.com)

 

[bobjames]

What's the problem with Adobe? I really think PDF is the way to go for distributing reports online and I don't think it's that hard. Plus they look great.

How are you exporting to word anyway? are you exporting to a Text file? Have you tried RTF (Rich Text Format)? In my experience it's hard to get the report to look decent and you mess with each report individually. It's a pain.

 

[lnoles]

The only 2 ways I got around this problem was to either use Adobe Acrobat or Micorsoft's Snapshot viewer. Both require the recipient to have a plugin on their machine. Snapshot is free from Microsoft and the viewer for pdf files is free. You have to buy the Adobe Acrobat Writer.

 

[J Colligan]

Thanks for the help so far. Unfortunately The manager-level reviewing the reports prevents the use of add-ins. If they can't click on the attachment in a CCMail e-mail they are going to call my assistant and request a hard copy, grim reality, but a reality all the same. MicroSoft Word seems to be the only attachment "clickable" and "Readable" from the remote access machines these executives use. If I can't solve it as described, my assistant will continue to fax hard copies to the manager's assistants. grim reality, but a reality all the same. Thanks Though!, Joe

 

[RpbertS]

hey J,

I have created reports and have had to send them to management before so I understand where you are coming from, what mail client do you use? more importantly is it Outlook? this may be to simple but when you view the report have you gone to file/send? and then tried RTF or an html document?(with HTML you'llhave to make a basic template fo rit. if you use outlook it'll export it right to an email message and you just have to pick the names,

hope this helps,
Rpb