A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

WordMerge97



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2004, 04:11 PM
external usenet poster
 
Posts: n/a
Default WordMerge97

Hi All


I have Just downloaded a script from

http://www.attcanada.net/%7ekallal.m...ordMerge97.zip

It works just great

I have emailed the chap who wrote the script But had nothing back as yet
I would think that he is to over worked with other stuff to bother about support for free scripts

What I'm trying to do is this

He as two buttons on the form

1 does single merge and the other does ALL merge

What I want to do is have a select box where I can select certain records then mail merge them

I have made unbound select text box with
row source type as table/query
Row source select distinction etc
with multi select BUT that does not work

I just wondered if you had done anything like that with his script?

regards

John

  #2  
Old June 3rd, 2004, 08:38 PM
Albert D. Kallal
external usenet poster
 
Posts: n/a
Default WordMerge97

Hum...don't recall getting the email! (did it bounce back on you?).

What I'm trying to do is this

He as two buttons on the form

1 does single merge and the other does ALL merge

What I want to do is have a select box where I can select certain records

then mail merge them


The above is quite a wide question. As "how" do you want to find and display
records in that list?

Will the person look, find, slice/dice and "THEN" decide to add to the merge
list?

So, really, it depends on how many names you have to display. (you can't
display 5000 names in a listbox, and have the user plow throw that many
names..and then select a few records?

So, the first question is how you will display those names?

Also, how many names can/will you have in the list?

I would suggest you simply add a [x] check box field to the screen. You then
can lookup and find the record you want, click on the "sendMailing" check
box. You do this for as many records as you need to select.

You see, the real issue is "how" do you plan to find those records? (and, no
doubt you have provided and worked very hard to use a good means for users
to find records now..right? (after all, how can they effectively use your
application if they don't have a way to find, and lookup a name now). So,
buy adding a simply check box field called "MyMailing", then you can use
your EXISTING means to find a record, and then check the box.

You then can make a simply button on a form that you launch at the end of
the day (or AFTER you have found and checked all the names to mail to).

You then go:

dim strSql as string

strSql = "select * from tblCustomers where MailTo = true"

MergeAllWord (strSql)

that is all you need. However, after you are done the above, you then need
to "clear" all the check boxes. You would ONLY want to check the boxes AFTER
you ensure all the letter get printed, and paper did not jam etc.

The code to re-set all the checkboxes could be a simply button, and the code
could be:

currentdb.Execute "update tblCustomers set MailTo = false"

and, for some ideas on searching/looking for names...you can read the
following:

http://www.attcanada.net/~kallal.msn/Search/index.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


  #3  
Old June 3rd, 2004, 08:41 PM
Albert D. Kallal
external usenet poster
 
Posts: n/a
Default WordMerge97

And, yes..I did get the email...but had not yet read/replied to all my
personal email just quite yet...I get a lot....



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


  #4  
Old June 4th, 2004, 11:02 AM
external usenet poster
 
Posts: n/a
Default WordMerge97

On Thu, 3 Jun 2004 13:38:45 -0600, in microsoft.public.access.forms you wrote:
Hi Albert


Please below comments

Hum...don't recall getting the email! (did it bounce back on you?).


No It did not
===============================

What I'm trying to do is this

He as two buttons on the form

1 does single merge and the other does ALL merge

What I want to do is have a select box where I can select certain records

then mail merge them


The above is quite a wide question. As "how" do you want to find and display
records in that list?


Ok to explain in more detail
I have a list box
It gets the data from
Row Source Type "table/Query
Row Source is
SELECT DISTINCTROW customers.Surname, customers.Firstname FROM customers ORDER BY customers.Surname;
the event
after update [Event Procedure]
the Event Procedure code
=====================================
code start
Sub List40_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Surname] = '" & Me![List40] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
========================================

So All i do from the list box is left mouse click on one of the names and it puts that name in all the fields on the open form
frmcustomers.
No Problem all works fine

NOW what I have been trying to do is make that list box a MULTI list box

So I can select the first name then hold ctrl key and select anymore in that list box I want

So I could select smith,jones,brown etc
Then press a button merge selected

This is where I'm having trouble
================================================== =========
Will the person look, find, slice/dice and "THEN" decide to add to the merge
list?


As above select from the list box
==============================


So, really, it depends on how many names you have to display. (you can't
display 5000 names in a listbox, and have the user plow throw that many
names..and then select a few records?


Yes I understand the above
BUT this will have no more than 500
============================================
So, the first question is how you will display those names?

A form frmcustomers which will have the list box on it
================================================
Also, how many names can/will you have in the list?

It will show all names in the table "tblcustomers" Like Surname.Firstname BUT as I say max of 500
================================================== =========
I would suggest you simply add a [x] check box field to the screen. You then
can lookup and find the record you want, click on the "sendMailing" check
box. You do this for as many records as you need to select.


Yes done that and all works fine BUT
I do not think I could relies on the customer to take the ticks out after they have put them in )
================================================== ================
You see, the real issue is "how" do you plan to find those records? (and, no
doubt you have provided and worked very hard to use a good means for users
to find records now..right?


Ha Ha Ha you bet been going round in circles
========================================
(after all, how can they effectively use your
application if they don't have a way to find, and lookup a name now). So,
buy adding a simply check box field called "MyMailing", then you can use
your EXISTING means to find a record, and then check the box.


Yes that is very good way BUT as I say above I think they would gorget to take out the dam ticks afterwards
================================================== =======
You then can make a simply button on a form that you launch at the end of
the day (or AFTER you have found and checked all the names to mail to).

You then go:

dim strSql as string

strSql = "select * from tblCustomers where MailTo = true"

MergeAllWord (strSql)


Yes all worked fine
=================================
that is all you need. However, after you are done the above, you then need
to "clear" all the check boxes. You would ONLY want to check the boxes AFTER
you ensure all the letter get printed, and paper did not jam etc.

The code to re-set all the checkboxes could be a simply button, and the code
could be:

currentdb.Execute "update tblCustomers set MailTo = false"


Ha Ha Ha I had a problem with the above it kept coming back variable not defined
so I put
DoCmd.RunSql "update tblCustomers set MailTo = false", -1

It seams to work ok
===============================================

and, for some ideas on searching/looking for names...you can read the
following:

http://www.attcanada.net/~kallal.msn/Search/index.html



Yes very good page learnt a lot from that thank you

As always, any and all help is greatly appreciated.

Thank you in advance.

John

PLEASE NOTE REAL EMAIL


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.