473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Mail Merge Access 97 and Word

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
15 2029
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
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

"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
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
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
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
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

"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
"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

"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
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
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
"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
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


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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Squirrel | last post by:
Hi everyone, I've created a mail merge Word doc. (using Office XP) , the data source is an Access query. Functionality I'm attempting to set up is: User sets a boolean field to true for...
9
by: Neil Ginsberg | last post by:
I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access...
3
by: Andy Davis | last post by:
I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge...
0
by: Linda Cacina | last post by:
Hello all you fine folks, Here is some code I am using to merge data from a single record Access 2K3 table into a NEW word document based on a pre-defined Word merge template doc. All I want to...
4
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and...
4
by: lesperancer | last post by:
I have 3 tables (office97) tblQuote quoteNbr tblDetails ( quote : 1 <-> M: quoteDetails) quoteNbr detailLine product value
1
by: ckirby | last post by:
I've inherited an application for creating mail merges from an Access 2003 ADP that needs an overhaul. To generate the mail merge , the app uses a shell command: result = Shell(str, vbHide) ...
8
by: Ron B | last post by:
Help!!! What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table. I want to...
6
by: crealesmith | last post by:
Firstly, I have no problem with mail merging to Word, VB code for that works perfectly. On one mail merge I need to merge 15 fields of data that are from 3 seperate records. The 3 records are all...
1
by: Esther Lane | last post by:
Hello! First off, many many thanks to Albert who wrote the Mail Merge code for MS Access I am using. It has been working beautifully for a few years. However, my client just (without notice!)...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.