Well, I've been doing this stuff for about 30 years now. Don't get me wrong, I have nothing but respect and admiration for teachers, especially in public schools. However, many of them don't have a lot of practical, real-world experience.
Wonderful work, very clear instructions, very easy to understand & follow. Very well done & thanks for creating such a wonderful resource for home learning
dude... i failed 12th grade, im re-doing computer application technology, i must say your videos are really getting me through this year, i thought i lost all hope for a second, thank you!!
Don't lose hope. I failed 12th grade too. I was in Honors English and my teacher was a major ass. So here I was, 17 years old, in summer school, with a baby on the way too!
I like your training courses because you made them easy to understand. Thank you. I paid for your microsoft access level 2 tutorial but cannot download it please help. God bless. Cordelia UK
If you're having problems watching your lessons or downloading, just contact customer service at 599cd.com/ContactForm and we're always happy to help you out. Also, there are WalkThru tutorials to explain how to download at 599cd.com/XGS
Thank you for making this video Rich! I know it was a long time ago. Would you consider doing an updated version for doing mail merge through code? That's something that's getting on my nerves right now.
I would like to use this feature in a different way. I have a set of records in the Excel sheet file, and each record carries a number, date and other information, and I would like to create a Word document with the record number and date only. Can I do this or is there another way, even if it is using a VB Code.
Thank you Rick for the tutorial.. very good and explicit. However; I do have an interrogative.. From a list I want to be able to print the number of items multiply for the qty amount.. i some cases may be 4 or 5.. in others just one label..
This is really helpful! But I have a question, I am creating a databse system for a client, ( this is for academic coursework) I need to know how to create an easy to use interface for the client who wants to be able to send premade mail merge emails to individual customers on access. 1) please can you explain to me how to do this? 2) Can you some how send the email to the recipiant without having to externally go onto outlook or online email systems to send it. So the my client will not have to go out of access to do so please? Thankyou so much in advance! :D really need help!
When I do this, I get a message that says "ODBC Microsoft Access Driver Login Failed. Could not find file C:\Users\dhudson\Desktop.mdb." What is causing this to happen?
Yes. You can export a table directly to a Word RTF file which will appear as a table in your document. I cover this in my Access Expert 19 class: 599cd.com/XAC13X19
Hey Rick, thanks, love the tutorials. I am having a problem in my access for mail merge - when going to the External Data tab the Word Merge is not accessible. What is the issue here, do you know?
Hi Robert, Many ail merges won't work correctly (which is my job) because I get a lot of files where data not in the right fields. I have used queries to move data into the correct fields, HOWEVER, it's very time consuming, as the key words I use to target that information is not consistent. I have to convert improper data into proper first. I have no control on the data entry end. Only after the fact. I know how to target key words and fix them safely, but haven't been able to target more than one key word in the same field and standardize them all at once. The quantity of words or partial words is easiliy 250 in one category and another 150 in a different category. I do have these typed up in excel, and have tried building various SQL commands around them to be used in ACCES, but none working beyond one word at a time.
See it this helps: 599cd.com/AutoText I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.
I keep getting an error that says "the database has been placed in a state by user 'Admin' on machine 'XXX' that prevents it from being opened or locked. It's a database with a sharepoint backend
hi, this is a really helpful function. But i have a problem, when i click word merge function the next message appears: "The mail merge wizard cannot continue because the database is in exclusive mode. Close and reopen the database to run this wizard".... and thats all I cant run it! Help me please!
your explanation is better than my teachers
Well, I've been doing this stuff for about 30 years now. Don't get me wrong, I have nothing but respect and admiration for teachers, especially in public schools. However, many of them don't have a lot of practical, real-world experience.
Easy to follow, straight to the point. This is my type of tutorials.
My pleasure.
Thank you VERY much! You've saved me and my colleagues MANY hours of work!
Glad to help
Wonderful work, very clear instructions, very easy to understand & follow. Very well done & thanks for creating such a wonderful resource for home learning
Welcome. :)
cant believe this is gonna help me out in exams ty ty
How did you do on those exams 4 years ago?
dude... i failed 12th grade, im re-doing computer application technology, i must say your videos are really getting me through this year, i thought i lost all hope for a second, thank you!!
Don't lose hope. I failed 12th grade too. I was in Honors English and my teacher was a major ass. So here I was, 17 years old, in summer school, with a baby on the way too!
Thanks mate, simple but informative video.
You're welcome
I like your training courses because you made them easy to understand. Thank you. I paid for your microsoft access level 2 tutorial but cannot download it please help. God bless. Cordelia UK
If you're having problems watching your lessons or downloading, just contact customer service at 599cd.com/ContactForm and we're always happy to help you out. Also, there are WalkThru tutorials to explain how to download at 599cd.com/XGS
Thanks so much... The instruction here was quick and easy to understand. Thanks again, it is awesome.
My pleasure.
Thanks so much for the mail merge
welcome
I enjoyed this video.. It was of great help.
Thank you!
Welcome
Thank you for making this video Rich! I know it was a long time ago. Would you consider doing an updated version for doing mail merge through code? That's something that's getting on my nerves right now.
I'll be doing this with Word Automation in an upcoming Developer lesson.
Thanks for saving me, I've picked up 5 extra marks xD
Glad I could help!
Such a marvelous work, it really helped me
Thank you!
This was very helpful! Thank you for posting!
Welcome
Thanks for the clear and step by step explanation that was easy to follow.
Thanks
nice lesson,
many thanks
You are welcome!
Thank you so much. You are a lifesaver.
You are very welcome. Glad you enjoyed!
I would like to use this feature in a different way.
I have a set of records in the Excel sheet file, and each record carries a number, date and other information, and I would like to create a Word document with the record number and date only. Can I do this or is there another way, even if it is using a VB Code.
Sure. See the extended cut:
Document Index: 599cd.com/DocumentIndex
Thank you, this was really helpful
Welcome
Thanks now I will pass my exam tomorow lol
How'd you do?
@@599CD how should i know haha it was 3 years ago
Thank you Sir. But how about the image mail merge?
That's a whole different lesson.
Thank you Rick for the tutorial.. very good and explicit. However; I do have an interrogative.. From a list I want to be able to print the number of items multiply for the qty amount.. i some cases may be 4 or 5.. in others just one label..
I cover that in 599cd.com/MailingLabel
This is really helpful!
But I have a question, I am creating a databse system for a client, ( this is for academic coursework) I need to know how to create an easy to use interface for the client who wants to be able to send premade mail merge emails to individual customers on access.
1) please can you explain to me how to do this?
2) Can you some how send the email to the recipiant without having to externally go onto outlook or online email systems to send it. So the my client will not have to go out of access to do so please?
Thankyou so much in advance! :D
really need help!
You lost me at "academic coursework." I haven't done homework since 1989.
When I do this, I get a message that says "ODBC Microsoft Access Driver Login Failed. Could not find file C:\Users\dhudson\Desktop.mdb." What is causing this to happen?
Well it sounds like it can't find that file
Can I transfer data in access to word as table
Sure. I recommend exporting to Excel first. Make it pretty, then copy that to Word.
@@599CD just from access to word without excel. I need that .just in one step I get datas 😊
Yes. You can export a table directly to a Word RTF file which will appear as a table in your document. I cover this in my Access Expert 19 class: 599cd.com/XAC13X19
Hey Rick, thanks, love the tutorials. I am having a problem in my access for mail merge - when going to the External Data tab the Word Merge is not accessible. What is the issue here, do you know?
I'd need to know more about what's happening.
Wow!! really clear many thanks!!!
My pleasure.
thanks , what if I have an Image in my data ?
Good Question. I think I will use reports for mail merge. Why not?
Don't store images in your tables
Hi Robert, Many ail merges won't work correctly (which is my job) because I get a lot of files where data not in the right fields. I have used queries to move data into the correct fields, HOWEVER, it's very time consuming, as the key words I use to target that information is not consistent. I have to convert improper data into proper first. I have no control on the data entry end. Only after the fact. I know how to target key words and fix them safely, but haven't been able to target more than one key word in the same field and standardize them all at once. The quantity of words or partial words is easiliy 250 in one category and another 150 in a different category. I do have these typed up in excel, and have tried building various SQL commands around them to be used in ACCES, but none working beyond one word at a time.
See it this helps: 599cd.com/AutoText
I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.
I keep getting an error that says "the database has been placed in a state by user 'Admin' on machine 'XXX' that prevents it from being opened or locked. It's a database with a sharepoint backend
Probably a permissions error.
hi, this is a really helpful function. But i have a problem, when i click word merge function the next message appears: "The mail merge wizard cannot continue because the database is in exclusive mode. Close and reopen the database to run this wizard".... and thats all I cant run it! Help me please!
I know it's been a while, but do you still need help with this question? If so, please see: 599cd.com/StillNeedHelp
Thank You So Much Sir
Welcome
Thank you!
You're welcome
Thanks and much appreciated.
My pleasure.
How to solve " The mail merge Wizard cannot continue because the database is in exclusive mode"
Don't open the database in exclusive mode.
This is a great video
My pleasure
Thanks sir!
i am doing this mail merge on the 15th of march 8 years later
Sweet
great work keep it up
Thanks