邮件合并Access 97和Word [英] Mail Merge Access 97 and Word

问题描述

他们想用word打印一些卡片4到一页

预先格式化来自访问数据库的东西。

这个问题是他们不是''我想两次做同一张卡。


如何在表格中设置变量进行打印，并在合并时从

字更新？


我想到了单词中的宏，但在我的工作中，他们在所有系统上都有宏关闭

。


非常感谢任何帮助或想法


Jerry

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

推荐答案

你不喜欢吨。你从Access中运行整个事情。


运行合并。 （Albert Kallal在他的网站上有一个很好的例子）

提示用户打印好吗？使用MsgBox。

如果intReply = vbYes那么

docmd.openquery更新所选记录

结束如果

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

您是否考虑过使用标签报告而不是邮件合并？

您可以设置报告以打印四页到一页。你可以通过这种方式获得更多控制权。

。


-

PC数据表

你的访问，Excel和Word应用程序的帮助资源
re******@pcdatasheet.com
www.pcdatasheet.com

" sparks" < JS ****** @ swbell.net>在消息中写道

news：7r ******************************** @ 4ax.com ...

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

他们想要用word将一些卡片打印成一张页面
来自访问数据库的预先格式化的东西。
这个问题是他们不是''我想两次做同一张卡。

如何在表格中设置一个变量进行打印，并在合并时从
字词更新它？

我想到了字中的宏，但在我的工作中，他们在所有系统上都关闭了宏。

任何帮助或想法都非常感谢

Jerry

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

" PC数据表" <无**** @ nospam.spam> schreef在bericht新闻：JP **************** @ newsread3.news.atl.earthli nk.net ...

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:JP****************@newsread3.news.atl.earthli nk.net...

你有没有考虑过这样做标签报告而不是邮件合并？
您可以设置报告以打印四页到一页。您可以通过这种方式获得更多控制权。

-
PC数据表
您的资源以获取Access，Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com

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

可怜的史蒂夫，你还是不明白......这不是*游戏......

你不能发布就像什么都没发生一样。


全部：解释等等回答史蒂夫： http://home.tiscali.nl/arracom/stopsteve。 HTML

很明显史蒂夫不是在这篇文章中做广告/求职，*但是* ...

==>可悲的是，这是第二次真正的狩猎开始。


再次：阻止史蒂夫的想法就像这样简单：

==>寻找* PCD的每个*帖子，无论他是否做广告。

==>直到他停止广告/求职。


************************************** ************ **

史蒂夫，他再次开始了他公然的广告和求职......

**** ********************************************** **

- 你滥用这个群体和其他人一次又一次地找工作和广告

- 当他们要求你停止这个时，你在这里侮辱很多人/>
- 你在提问时隐藏你的身份

- 你试图出售一张CD（

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 (

这篇关于邮件合并Access 97和Word的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！