exporting a report

[WaltLukeIII]

I am trying to export someinformation that is in a report in that format can anyone help. I am trying to do it through a button on a form.<br><br>I have tried to use <br>docmd.transfertext acExportFixed <br>with all the other parts but I cannot figure out the <br>namespecification. <br><br>thanks <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[PaulF]

check out:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OutputTo<br><br>PaulF

 

[Quehay]

Isn't it better to export the query on which the report is based?&nbsp;&nbsp;Reports turn into a lot of extra space and such when<br>exported.&nbsp;&nbsp;The&nbsp;&nbsp;DoCmd. output to has a query constant. . .

 

[WaltLukeIII]

I want the output to look as professional as possible and I would like it to look as much like the report as possible. It would be for attaching to emails sent to other companies. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[JimConrad]

Your might want to view <A HREF="

http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm"

TARGET="_new">

http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm</A>

for information about the Access Report Snapshot Viewer.<br><br>You can create a snapshot of a report into a file that your user can view (without Access!).&nbsp;&nbsp;The report will look EXACTLY like it does in Access. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>

 

[Quehay]

Jim's right--the Snapshot is definitely the way to go--I misunderstood your intention as being to get it into Excel.&nbsp;&nbsp;I have a page with option group to select one of a group of reports <br>and buttons to then preview,print, or email.&nbsp;&nbsp;The email option of do.cmd sends you into a chose format dialogue then into outlook with the Snapshot file already attached.&nbsp;&nbsp;If your recipipient doesn't have Access or right version they can view it (and print) just as it appears--it's great!