By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Mail Merge Access 97 and Word

P: n/a
They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.

How can setup a variable in the table for printed and update it from
word when I do a merge?

I thought about macros in word but at my work they have macros turned
off on all systems.

any help or ideas are greatly appreciated

Jerry

Nov 13 '05 #1
Share this Question
Share on Google+
15 Replies


P: n/a
You don't. You run the whole thing from within Access.

Run Merge. (Albert Kallal has a nice example on his website)
prompt user for "Printed OK?" using MsgBox.
If intReply=vbYes then
docmd.openquery "update selected records"
End if

Nov 13 '05 #2

P: n/a
Have you considered doing this with a label report rather than mail merge?
You can set up the report to print four to a page. You get more control
doing it this way.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"sparks" <js******@swbell.net> wrote in message
news:7r********************************@4ax.com...
They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.

How can setup a variable in the table for printed and update it from
word when I do a merge?

I thought about macros in word but at my work they have macros turned
off on all systems.

any help or ideas are greatly appreciated

Jerry

Nov 13 '05 #3

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:JP****************@newsread3.news.atl.earthli nk.net...
Have you considered doing this with a label report rather than mail merge?
You can set up the report to print four to a page. You get more control
doing it this way.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


Poor Steve, you still don't understand... This is *not* a game...
You can't post just like nothing happened.

To all: Explanation and more on this answer to Steve: http://home.tiscali.nl/arracom/stopsteve.html
It is clear that Steve was NOT advertising/jobhunting in this post, *but* ...
==> Sadly enough this is the second time a real 'hunt' has started.

Again: The idea to stop Steve is as simple as this:
==> Hunt *every* post of PCD, no matter if he is advertising.
==> UNTIL he stops the advertising/jobhunting.

************************************************** **
To Steve, who started his blatant advertising and job-hunting again ...
************************************************** **
-- You abuse this group and others for job-hunting and advertising over and over again
-- You are insulting lots of people here when they ask you to stop this
-- You hide your identity while asking questions
-- You try to sell a CD ($125,--) with FREE code you gathered from these groups here
-- You posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ???
(the latest 'star's': 'Access Resource' and Tom no***@email.com)
-- There even has been a 'Scam-alert' about you which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp....954261f9?hl=en

-- Recently it became clear that you have been spamming innocent people asking questions:
http://groups.google.com/group/comp....3e5f58ad?hl=en

So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******

Arno R
Nov 13 '05 #4

P: n/a
Thanks to everyone will give it a try and see if that is what they
want. As usual as soon as they get EXACTLY what they want, I get
is that what we asked for? LOL

Jerry
On 20 Sep 2005 13:44:37 -0700, pi********@hotmail.com wrote:
You don't. You run the whole thing from within Access.

Run Merge. (Albert Kallal has a nice example on his website)
prompt user for "Printed OK?" using MsgBox.
If intReply=vbYes then
docmd.openquery "update selected records"
End if


Nov 13 '05 #5

P: n/a
Bri

StopThisAdvertising wrote:
Poor Steve, you still don't understand... This is *not* a game...
You can't post just like nothing happened.

To all: Explanation and more on this answer to Steve: http://home.tiscali.nl/arracom/stopsteve.html
It is clear that Steve was NOT advertising/jobhunting in this post, *but* ...


Arno,

Sadly, in this case *YOU* are the one who comes off as the newsgroup
abuser. If Steve advertises, then blast him, but if he isn't (your own
statement that this e-mail wasn't advertising) then leave him be.

--
Bri

Nov 13 '05 #6

P: n/a
Bri,
I can understand people who are not happy with this.
However I wonder if you actually did read the link I provided.

The plan to stop Steve, is to hunt *every* post, no matter if he's advertising or not.
I did *not* start this because of this thread... but because of these:
(microsoft.public.access.gettingstarted, all from last week)
-- Computer Inventory question
-- Still need to track attendance of bus riders
-- Before i throw myself into Access, a small question....
-- Building a database
-- Phone support
-- Help, no table

In all these threads advertising/jobhunting by PCDatasheet.
Same old story, same old song.
I am not the only person who told Steve these are free forums. His answer was posting another add.

If you see another way to stop this maniac?

Arno R
"Bri" <no*@here.com> schreef in bericht news:fhgYe.532402$5V4.176337@pd7tw3no...

StopThisAdvertising wrote:
Poor Steve, you still don't understand... This is *not* a game...
You can't post just like nothing happened.

To all: Explanation and more on this answer to Steve: http://home.tiscali.nl/arracom/stopsteve.html
It is clear that Steve was NOT advertising/jobhunting in this post, *but* ...


Arno,

Sadly, in this case *YOU* are the one who comes off as the newsgroup
abuser. If Steve advertises, then blast him, but if he isn't (your own
statement that this e-mail wasn't advertising) then leave him be.

--
Bri

Nov 13 '05 #7

P: n/a
Bri
Arno,

As I said, Blast the e-mails that advertise, ignore the others. This
combines both positive and negitive feedback. If you attack all of his
posts, good or bad, then there is no reason for him to change since he
will get blasted either way.

I have read your links and have followed all of your other posts in the
past reguarding this. I agree he needs to stop advertising, but I
disagree with blasting him when he does follow the rules.

--
Bri

StopThisAdvertising wrote:
Bri,
I can understand people who are not happy with this.
However I wonder if you actually did read the link I provided.

The plan to stop Steve, is to hunt *every* post, no matter if he's advertising or not.
I did *not* start this because of this thread... but because of these:
(microsoft.public.access.gettingstarted, all from last week)
-- Computer Inventory question
-- Still need to track attendance of bus riders
-- Before i throw myself into Access, a small question....
-- Building a database
-- Phone support
-- Help, no table

In all these threads advertising/jobhunting by PCDatasheet.
Same old story, same old song.
I am not the only person who told Steve these are free forums. His answer was posting another add.

If you see another way to stop this maniac?

Arno R
"Bri" <no*@here.com> schreef in bericht news:fhgYe.532402$5V4.176337@pd7tw3no...
StopThisAdvertising wrote:

Poor Steve, you still don't understand... This is *not* a game...
You can't post just like nothing happened.

To all: Explanation and more on this answer to Steve: http://home.tiscali.nl/arracom/stopsteve.html
It is clear that Steve was NOT advertising/jobhunting in this post, *but* ...


Arno,

Sadly, in this case *YOU* are the one who comes off as the newsgroup
abuser. If Steve advertises, then blast him, but if he isn't (your own
statement that this e-mail wasn't advertising) then leave him be.

--
Bri


Nov 13 '05 #8

P: n/a

"Bri" <no*@here.com> schreef in bericht news:V8iYe.244843$Hk.14795@pd7tw1no...
Arno,

As I said, Blast the e-mails that advertise, ignore the others. This
combines both positive and negitive feedback. If you attack all of his
posts, good or bad, then there is no reason for him to change since he
will get blasted either way.

I have read your links and have followed all of your other posts in the
past reguarding this. I agree he needs to stop advertising, but I
disagree with blasting him when he does follow the rules.


You sound very reasonable Bri.

I just can't think of another way to stop this advertising/jobhunting maniac.
Attacking only the advertising did not help that much in the past.
Discussion with Steve only results in 'word-twisting'.

His real name is his weak point. He can't hide his real name ...
The earlier threads on this at least have resulted in Steve going away for a while.

(He 'promised' me to do some homework ...)

There has been hardly any advertising here in the groups in the two periods that Steve was gone.
As far as I am concerned he might as well stay away.

But as I said, your opinion sounds very reasonable.
If more people think like you, I will reconsider this 'hunt'.

Arno R
Nov 13 '05 #9

P: n/a
"StopThisAdvertising" <StopThisAdvertising@DataShit> wrote in
news:43********************@dreader2.news.tiscali. nl:
If you see another way to stop this maniac?


Arno, do you want to land in everyone's killfile? If you insist on
responding to someone in CDMA based on posts they've made somewhere
else (I don't read any other Access newsgroups), then *you're* the
one who is annoying the hell out of me, and ^you're* the one whose
posts will be ignored by increasingly large numbers of CDMA readers.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #10

P: n/a

"David W. Fenton" <dX********@bway.net.invalid> schreef in bericht news:Xn**********************************@216.196. 97.142...
Arno, do you want to land in everyone's killfile? If you insist on
responding to someone in CDMA based on posts they've made somewhere
else (I don't read any other Access newsgroups), then *you're* the
one who is annoying the hell out of me, and ^you're* the one whose
posts will be ignored by increasingly large numbers of CDMA readers.

OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is annoying the hell out of me.

Arno R
Nov 13 '05 #11

P: n/a
rkc
Arno R wrote:
OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is annoying the hell out of me.


Lighten up, dude. Life 's too short.
Nov 13 '05 #12

P: n/a
One more question on this if I may.
I called them and told them that I needed a word template so I could
set this up.
Their response.....template?

yea how its going to print and what.

I got the same thing I have been dealing with for over a year.
DAMN Access!!!!
If they would have gone foxpro like I told them we wouldn't have these
damn problems!!!!!!!!!!!!!!!!

huh?

anyway it is now my job to set up a template for something I know
nothing about and give them the info that they don't know what it is
in a format that is,what. With variables that I don't know what they
want.

WTF
because foxpro could do it. Seems that some B that works in the head
office has a husband that works somewhere that uses foxpro and
anything that is mentioned about data or databases well foxpro can do
that.

I also program sas so I guess foxpro is better at data analysis as
well.

anyway is there a place to dl preformatted templates?

thanks big time
soon to be unemployed

Jerry

On Tue, 20 Sep 2005 20:41:51 GMT, sparks <js******@swbell.net> wrote:
They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.

How can setup a variable in the table for printed and update it from
word when I do a merge?

I thought about macros in word but at my work they have macros turned
off on all systems.

any help or ideas are greatly appreciated

Jerry


Nov 13 '05 #13

P: n/a
"Arno R" <ar***********@tiscali.nl> wrote in
news:43********************@dreader2.news.tiscali. nl:

"David W. Fenton" <dX********@bway.net.invalid> schreef in bericht
news:Xn**********************************@216.196. 97.142...
Arno, do you want to land in everyone's killfile? If you insist
on responding to someone in CDMA based on posts they've made
somewhere else (I don't read any other Access newsgroups), then
*you're* the one who is annoying the hell out of me, and ^you're*
the one whose posts will be ignored by increasingly large numbers
of CDMA readers.


OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is
annoying the hell out of me.


You can't tell me anything about being annoyed by someone else's
posts, as you should well remember.

The way to deal with people who annoy you is to killfile them and
ignore them. It will keep the newsgroup cleaner and lower your blood
pressure.

And I've Been There and Done That, so I think I have a right to give
this advice to you.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #14

P: n/a
sparks <js******@swbell.net> wrote in
news:ih********************************@4ax.com:
anyway is there a place to dl preformatted templates?


If you need a template for a mail merge, it seems to me that a
preformatted template won't do the job.

Don't use word "template" -- just ask them for an example of how
they want the results to look. That would include document text,
which they *must* provide for you (unless they are like the website
clients who think the web developer should write all the content on
the website).

In cases where the client tells me some other product can do it I
will just tell them "Fine -- use that other product. But I guarantee
that you'll find it's not as simple as you think and you'll come
back to me to finish it in Access."

If they don't like that, well, there's not much point in *wanting*
to continue the project.

Sometimes the developer should FIRE the client.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #15

P: n/a


David's on the right track for this!

All I do is ask them to "Mock-up" document in Word of what they want
the end result to look like. I then take that document and turn it
into a document template. If they don't like the results....

Make sure you also say something like "Including whatever graphics
(logos or whatever) or legal wording that needs to be on the
document." If there _is_ any legal wording required, that will get
the proper people involved. (It's something that clients often
forget.)
On Thu, 22 Sep 2005 11:54:01 GMT, sparks <js******@swbell.net> wrote:
One more question on this if I may.
I called them and told them that I needed a word template so I could
set this up.
Their response.....template?

yea how its going to print and what.

I got the same thing I have been dealing with for over a year.
DAMN Access!!!!
If they would have gone foxpro like I told them we wouldn't have these
damn problems!!!!!!!!!!!!!!!!

huh?

anyway it is now my job to set up a template for something I know
nothing about and give them the info that they don't know what it is
in a format that is,what. With variables that I don't know what they
want.

WTF
because foxpro could do it. Seems that some B that works in the head
office has a husband that works somewhere that uses foxpro and
anything that is mentioned about data or databases well foxpro can do
that.

I also program sas so I guess foxpro is better at data analysis as
well.

anyway is there a place to dl preformatted templates?

thanks big time
soon to be unemployed

Jerry

On Tue, 20 Sep 2005 20:41:51 GMT, sparks <js******@swbell.net> wrote:
They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.

How can setup a variable in the table for printed and update it from
word when I do a merge?

I thought about macros in word but at my work they have macros turned
off on all systems.

any help or ideas are greatly appreciated

Jerry

--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

Nov 13 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.