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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|