Bill, I'm sorry I didn't sign with my name, I'd assumed the forum software does it but I was wrong.
I can assure you, many of the "users" here will have saved many word documents merged from Access tables and will have done so in many different ways.
XPS is *not* an Excel format, it's a so-called "page description" format and is Microsoft's answer to PDF.
I have many thousands of users merging Word Documents to Access Data and getting the documents saved in various formats. One part of the application saves to Word format with a password and another part saves to PDF/A (effectively view/print only.)
This is almost certainly not a question of your or anyone else's skill level in Access or Word but in communicating. So, please tell us more precisely what you are doing and we can more precisely help you with your question.
Yours,
Andrew
--- In MS_Access_Professionals@yahoogroups.com, "WS Cook" <wscook@...> wrote:
>
> Thanks for commenting Craven
>
> If any user takes the trouble to try to save a word doc that was merged with
> info from an Access table, they will observe the it can only be saved as an
> xps file. No big deal there! But when you try to open the saved xps file it
> can not be opened, because it is a word doc not an excel file, which makes
> it a useless saved file. One of the issues not addressed is that I often
> take work product home to modify or use the correspondence from my home
> computer so I can not re-create the document at home.
> I am surprised that Crystal and other users have not encountered the
> associated problems with not being able to use a word doc in the normal
> fashion after it is completed with an Access merge. I am confident a
> skilled Access programmer could create complex secondary tables to solve the
> simple task of salvaging or saving a merged word document, but that ain't
> me.
> Bill Cook
>
>
> ----- Original Message -----
> From: "acravenrohm" <yahoo@...>
> To: <MS_Access_Professionals@yahoogroups.com>
> Sent: Wednesday, December 21, 2011 6:41 AM
> Subject: [MS_AccessPros] Re: merge utility
>
>
> With all due deference to Crystal, there are good reasons to want to save
> the electronic copies of documents as printed.
>
> Next year I will ant to see the document in original, not the document as it
> would now look like. The person might have married and have a different
> Family name. The Bank account details might have changed, the account
> balance should have changed.
>
> You can maintains a history of the chanegd data in order to recreate the
> past but it's usually easier to keep a copy of the things you actually send
> out.
>
> Here, I suspect that the solution to Bill's Problem will become clearer once
> he describes exactly how he's saving the Document in/from Word. (I sounds
> like he's using ExportAsFixedFormat with ExportFormat set to
> wdExportFormatXPS but "sounds like" is just a guess.)
>
> Bill, sounds like you're doing this by hand?
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal
> <strive4peace2008@> wrote:
> >
> > Hi Bill,
> >
> > I have never tried to save a merged document
> >
> > why save the documents in electronic format?� You can always create them
> > again.� I keep track of which records have been merged into Access
> > through structure.� For instance, make a table for documents and
> > document templates.� Assume you already have a contacts table.� Then
> > simply make a table cross-referencing the 2 -- you can reprint any merged
> > document anytime.�
> >
> >
> > Warm Regards,
> > Crystal
> >
> > �*
> > �� (: have an awesome day :)
> > �*
> >
> >
> >
> >
> > ________________________________
> > From: WS Cook
> >
> > Crystal and Clive
> > I create a table in Access that list insurance company, address, claim
> > number, drivers name, ETC.
> > I then bootup MS Word to create letters to send to the insurance company
> > and
> > merge my fields from the Access tables. Then I save the document in MS
> > Word
> > since I am in MS Word.� Later when I revist the saved document, it has
> > an
> > extension of "XPS" and Word responds that it can not open the document.
> > Effectivly I do not have a saved document for my records or additional
> > work.
> > In researching I read in Matthew MacDonald's "The Missing Manual" for
> > Access
> > 2007 that there was an add on patch from MS that would allow saving in a
> > format that would allow a change of the file extension to make it readable
> > in MS Word 2007.� I tried to make that happen and ended up with an
> > unworkable mess.� It seems that MS had a concern for infringment to
> > Adobe so
> > it decided a PDF file with such a process as I described was not necessary
> > and just left it out.� It is logical that such a super programs, that
> > Access
> > and Word are, would be able to let a neophite user complete such an
> > unsophisticated procees.
> > Merging Access with Word is not my issue as that is straight forward and
> > doable.� How to save the merged document is a stumbling block for me. I
> > look
> > at the complex issues that are queried and the learned response solutions
> > to
> > the complex issues in the forum and my problem seems like "Ned and the
> > First
> > Reader" See spot run.
> > I realize that I am in an Access Forum seeking advice for a Word issue but
> > it directly relates to Access merge.
> > Thanks for your time and any advices
> > Bill Cook
> > PS
> > my outlook spell checker does not work if any errors
> >
> > ----- Original Message -----
> > From: "Crystal" <strive4peace>
> >
> >
> > hi Bill,
> >
> > what kind of a merge are you doing? Using Access to supply fields for a
> > Word
> > merge? Using code to substitute bookmarks or something? Please give more
> > information and what is the problem? what version?
> >
> > warm regards,
> > Crystal
> >
> > * have an awesome day :)
> >
> >
> >
> > ________________________________
> > From: WS Cook
> >
> > Crystal
> > In looking at Mr. Toews blog I searched for any info on " Access merge to
> > word" and found the below entry. However I could not locate the utility.
> > My prior postings and queries on this subject were treated similar to if I
> > had asked the group "How do I make a table" so the query went unanswered.
> > I hope someone in the forum can direct me to a solution for an apparantly
> > infrequent shared "Access to Word" merge problem.
> > Bill Cook
> > *************
> > Access to Word Merge utility
> > I was reminded by a newsgroup posting of fellow Access MVP Albert Kallal's
> > excellent Access to Word Merge utility. Keep that one book marked as it is
> > easy to use and works well.
> >
> > Published Fri, Oct 17 2008 15:57 by Tony
> > Filed under: Access, Tips
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar