Dian, That's the whole point of VBA, if you know the object models you can program any of the Office applications to work with any other Office application. I have used Access VBA to use Powerpoint and Outlook both. I don't know the Word object model quite as well but given a little time, I could open it up and use it as I liked. I have also used Excel through Access as well. I would love to see them combine the Access concatantion ability and Word's formatting into the Access reporting module. You said you could fit pages in a single field in Word. Is there any way to make the fields shrink to fit whatever is entered if you aren't using Access as a backend? I personally hate using merge or even protected fields because if the input is too short, it tends to leave ugly gaps. James -----Original Message----- From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx] Sent: Friday, September 12, 2003 4:34 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: OT: Dian please AND OTHERS :VSMail mx3 >I completely agree Ray...I can make em just as pretty in Excel as I can in Word :-) Yeah, but can you program Excel to work with Access?<smirk> The facts are that more people have Word on their computers than they do Access. And more folks use Word than Access OR Excel. And if you build a solution in Word with Access...you don't need Access to even be on your computer! Yet the DB will still run and you just use it like any other document/software. And that's not only cool...but hits the largest market of users...those who can open a document/letter in Word. Granted...Excel is # 2...but I believe PPT might even run # 3 versus Access???? Dian D. Chapman Technical Consultant, Microsoft MVP & Instructor Free Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson Sent: Friday, September 12, 2003 11:34 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: OT: Dian please AND OTHERS I completely agree Ray...I can make em just as pretty in Excel as I can in Word :-) Linda F. Johnson, M.A., MOS Linda's Computer Stop www.personal-computer-tutor.com E-Books, Online Classes, free ABC ezine and lotsa other free stuff -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Blake Sent: Friday, September 12, 2003 12:19 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: OT: Dian please AND OTHERS And as for Word outputting prettier documents than Excel, that's fightin' talk, Dian. Ray ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************