Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

using mail merge by Albert D. Kallal have one thing I can't figure out

130 views
Skip to first unread message

sparks

unread,
May 4, 2011, 9:38:18 AM5/4/11
to

When this is run it works great.
UNTIL they start it and have a word document open.

it runs but the output is not there.
I understand that and only run my mail list when i DO NOT have a word
document open.

they have taken this at my work and gave the database to another
person. They run it and then shout crap code and everything else even
after being told to close any word documents before running it.

is there a way around this?
Can it be used while other word documents are open, I could not find a
way to do this.

Is there some way to check and see if any word documents are already
open and refuse to run and/or warn the user?

Albert D. Kallal

unread,
May 4, 2011, 6:16:45 PM5/4/11
to
"sparks" wrote in message
news:2fl2s6t6j42cd6hu0...@4ax.com...

>Is there some way to check and see if any word documents are already
>open and refuse to run and/or warn the user?

As a general rule, they should be able to have as many open documents as
they please.

I assume the command you are using in a form is:

MergeSingleWord

You might want to mention if there is some other detail you are leaving out,
or perhaps you are doing something different here.

You could and should also try download the latest version, and try the test
download, and see if that works.

http://www.kallal.ca/msaccess/msaccess.html

In above, scroll down to the super easy word merge.

So, as a general rule, they should be able to have many documents open, and
even documents that have nothing to do with the merge should not be
effected.

I not modified that code in some time, but I do often make some changes over
the years.

It not clear how old of a download copy you have, but try the above sample
nd see if it allows more then one document open, it should.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenos...@msn.com

yinka

unread,
Jan 31, 2014, 12:57:45 PM1/31/14
to
I am trying to use your wordmerge22simplifiedforAWFUser to merge info from access 2010 to word 2010. In addition to regular data, I included a graph in the form in access, but when I run the macro it merges only the data but doesn't merge the graph.

What do I need to do? Is there any modification that you have made recently that can allow the graph to change dynamically from one letter to another? I will greatly appreciate any help that you can give in this matter...either by way of modified macros or another solution that will let me merge both data and graphs from access into word 2010. Thanks a lot...Yinka


David Hare-Scott

unread,
Jan 31, 2014, 4:51:55 PM1/31/14
to
Mail merges use data from text fields. A graph on an Access form or report
is neither text nor a field but an embedded object. If I had to do this I
would forget about Word and create it all as an Access report that had a
graph object embedded. With a little work you can make a report look very
like a Word document when printed.

D

0 new messages