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
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
Not the best. I've had mixed results. Can you not just use the report as access creates it?
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?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
Already stated options I am aware of.
What do you mean by 'align text justify' - justify how (left, right, center, distribute)?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
I think that is the Distribute alignment.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How can we use distribute alignment. I only got Right, Left and Center alignment option in report.
I also have Distribute. Guess that is new in Access 2010. It doesn't really work well with multi-line text anyway.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.