exporting access report to ms word 2007

[joshynaresh]

Dear Sir,



can we expot access 2007 report to Ms word 2007 by vba code. if it is possible plz provide me some code.

Thanks in advance

[ranman256]

Not the best. I've had mixed results. Can you not just use the report as access creates it?

[June7]

Options:

1. mail merge

2. OutputTo method
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

As ranman says, output by export is often not satisfactory. Why do you need Word document?

[joshynaresh]

hi ranman256 ! I can't use report because align text justiy. due to lack of this option written sentence will not seems effective.Hi June7 ! Output To method's result is not satisfactory so i'm asking is there any vba code to export report to word with certain alignment.

[June7]

Already stated options I am aware of.

What do you mean by 'align text justify' - justify how (left, right, center, distribute)?

[joshynaresh]

Hi buddy !
Justify aline means "Align text to both the left and right margins, adding extra space between words as necessary. This creates a clean look along the the left and rights side of the page"

Thanks in advance

[June7]

I think that is the Distribute alignment.

[joshynaresh]

How can we use distribute alignment. I only got Right, Left and Center alignment option in report.

[June7]

I also have Distribute. Guess that is new in Access 2010. It doesn't really work well with multi-line text anyway.