ACCESS FEED: RE: [MS_AccessPros] Re: merge utility

Bill

We're not here just for developers. We are here for all users no matter what
their level of Access skills. Feel free to ask for help and we'll continue to do
our best to give it.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<http://mvp.support.microsoft.com/profile/Bill.Mosca>
http://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of WS Cook
Sent: Wednesday, December 21, 2011 5:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: merge utility

Crystal, Andrew, John and Bill
Thanks to all of you for sharing your thoughts and help.
This is a forum for MS-Acess Professionals and I am in the wrong arena.
I now realize that all have offered their best efforts to an Access
beginner.
I will now fold my tent and go back to a beginner forum where I belong.
You have a great group and I would be proud to be a qualified member with
comparable expertise. Knowing my limitations and skills are great building
blocks
for self improvment. The patience afforded my queries by all who responded
is appreciated and when
I get better with Access I may be back, but for now I move on.
Happy holidays to all and to all a good night..
Thanks
Bill Cook

----- Original Message -----
From: "Crystal" <strive4peace2008@yahoo.com
<mailto:strive4peace2008%40yahoo.com> >
To: <MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> >
Sent: Wednesday, December 21, 2011 7:57 PM
Subject: Re: [MS_AccessPros] Re: merge utility

Hi Bill,

the sure way to create and track documents is of course with code. Download
my utility to use Word Bookmarks instead of Word Fields to do merges with
Access. If you wish to substitute things more than one place than modify the
code to use Search/Replace instead of bookmarks.

Sample application showing how to create a Word document that you can save
from a Word template with Bookmarks for fields from Access:

http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/

and download

WriteToWord_MDB_DOT_TXT__Crystal.zip
Example to create a Word document and populate
it with information from Access. Contains a DOT file (Word Document
Template, WriteToWord.DOT), an MDB file (Access Database,
WriteToWord.mdb), and a TXT file with code and comments.

if you wish to make several documents, you can loop the code

~~~

so instead of initiating a merge from Word, you would initiate it from
Access

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: acravenrohm

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

--- , "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"
>
> 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
<mailto:MS_Access_Professionals%40yahoogroups.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

[Non-text portions of this message have been removed]