Thanks for the video. I was following until the macro part. Since I have no experience, I could not continue. It could be useful to place a link to go through how you created the macro as well. Thank you!!
@johannaklein576
2 жыл бұрын
This is amazing - I am absolutely non-technical, but I followed this and am freaking out that it works!
@jacksonqiu3373
4 жыл бұрын
The dogs are having fun in the background.
@andreapatane4204
2 жыл бұрын
This is interesting, because I want to learn how to do this for some inventory that I plan to do at home someday. My PC had problems getting all of the columns just right.
@danishs2893
4 жыл бұрын
The video was really good. I would like to post a doubt though. Here you have accessed one single row/data at a time. If i need to access the complete data and change it into this name slip/salary slip format, what is to be done ?
@mswsonu
2 жыл бұрын
love you krishna ... you saved my whole day of work
@christinakid6276
Жыл бұрын
How can we switch this around and export sentences with a specific word from a word doc to an excel spreadsheet?
@bayonictx8305
4 жыл бұрын
I have a problem. when merging files the numbers of the dates not like i want them to be -.-" exampel. on excel: 06-2015 // used custume edit mm-yyyy on word: 06/01/2015// it is adding a day and use slesh for the date. I cant change approved files for the way i want i need the dates will be mm-yyyy. please help :(
@user-me2xf4pi9x
5 жыл бұрын
Can the same process be used to autopopulate pictures for labels in Word? By pasting the pic URL in the spreadsheet? There are some printer softwares that will allow you to do this but Im having a ton of trouble with this.
@KrishSanj
5 жыл бұрын
let me check that. BTW, what as the label printer? is it zebra or somthing?
@Jmundle
4 жыл бұрын
Thank You so much for this it is extermely helpful. Is it possible to put the macor in a note pad I am having issue make the macro work I keep getting error
@KrishSanj
4 жыл бұрын
what is the issue?
@yaot8186
4 жыл бұрын
@@KrishSanj Sir, the Microsoft Word is not getting the data after running the macro. Only the "Preview Results" works
@yaot8186
4 жыл бұрын
@@KrishSanj Sir, I realised after going to John, you can still go down to Kate. But you cannot go back up to Krishna
@soniaalalwanii
3 жыл бұрын
@@KrishSanj The word document is not getting updated even after I enter name in the form. The macro runs but there is nothign that shows in the word doc.
@real1488madrid
3 жыл бұрын
Why macros is not working if you are inputting name manually, not copypasting from excel ?
@SuperGreath
4 жыл бұрын
Thank you for the tutorial! Can you please upload also the macro?
@mrscuteshoes
3 жыл бұрын
What if you have the same section repeated on the same page but need to fill with a different row from excel spreadsheet?
@kristinpangman8953
4 жыл бұрын
I can only get the Macro to run once before it stops working. I don’t get any error messages it just won’t run again using a different name. Any idea why??
@wghysens
7 жыл бұрын
Wow. This was now exactly what I was looking for! Excellent & clearly explained. Great job Krish!
@gururama7813
6 жыл бұрын
Have a scenario to save all the rows as individual documents how to achieve this pls ? It should create multiple files or split file basically . Kindly drop a reply.
@omnia9348
5 жыл бұрын
Up
@zebwalter7895
4 жыл бұрын
I want to use this idea to have a database with all of my stores products, and build the word doc for our price cards. But is there a way to toggle a row in excel so that if a product is out of stock it won’t print on the price card?
@KrishSanj
4 жыл бұрын
This video is specifically to query for a row. If you want to list multiple items in the Word, you can use different macro, which will publish all the data in the word. Check out my channel, for similar video. Let me know if you still need help
@SchwizzZer
4 жыл бұрын
Could anybody help in further automizing so that tables are copied and filled automatically? Thanks in advance!
@trixupberries5051
3 жыл бұрын
Hi , It worked until the mail merge perfectly, but after that I am not able to get the details of other names using the macro which u specified . Can you please help me out with where am going wrong
@KrishSanj
3 жыл бұрын
you might have missed some steps. can redo again and let me know
@carlogarcenila8040
Жыл бұрын
HI is there's a way to create a field to input the name instantly to not open the macro button for every input of the name
@KrishSanj
Жыл бұрын
Can you elaborate
@carlogarcenila8040
Жыл бұрын
@@KrishSanj Hi I would like to mail merge but end up saving all the individual documents separately rather than as one large document, but retain the ability for the individual documents to be auto updated with changes made in the excel. How is this possible?
@rajagopalan9043
6 жыл бұрын
Please can you solve this doubt, dates from the excel to word it is showing in number format. For e.g 03/04/2018 instead of this it is showing like this 45415. Please help me with this..
@KrishSanj
6 жыл бұрын
raja gopalan format the date in ms word
@rajagopalan9043
6 жыл бұрын
Thank you and how to remove automatically a specific text or dates while doing mail merge from excel to word. For (e.g) dates like 01/01/2001.
@rohitjindal9124
4 жыл бұрын
Can you please help to generate multiple file in one go and saved at particular Location with some particular name as per key field
@KrishSanj
4 жыл бұрын
check my channel there should a video on that. let me. if not will surely help you
@zuhaibahmed2700
3 жыл бұрын
Is it possible to automate the creating of a document for each key?
@KrishSanj
3 жыл бұрын
you mean for each record? That should be possible, check my channel I should have a video on that
@georgecheng9182
6 жыл бұрын
Good sharing and teaching, but i facing a problem currently. The script seem like unable to do a loop search of name. Example, if we done a search on SOMA, then we try to search back ward to JOHN, it will not able to do it. Able to help? Thanks
@KrishSanj
6 жыл бұрын
Can you please retry. I suppose you dont have any macro errors. That means it should work. Can you carefully follow the steps and let me know if you still face problems
@walter_ribeiro
5 жыл бұрын
Part of my job requires me to send questionnaire to suppliers so that I can draft commercial agreements. Is there a way to link the answers (excel sheets) to their respective fields in the agreement? For example, wherever they provide their commercial address, to transfer that to the field in the agreement where it is supposed to be their commercial address?
@Yprion
3 жыл бұрын
Absolutely incredible. Any Certification Enjoyers?
@christophergee270
5 жыл бұрын
I had a problem too. I copied the code and added mail merge fields, but when I ran the macro and inputted my key, nothing happened. All of the fields remain unchanged. My macro security is good - what else could be wrong?
@nagab797
5 жыл бұрын
Bro from where you copied the code
@saimali9296
2 жыл бұрын
I am facing a problem. The code is exactly the same but when you search say for example the 3rd record, then you can not search any previous record like 2nd or 1st but still you can search the record 4th and so on. Why?? please anyone else doing it please try and let me know if you have any solution, Thanks
@dawn5679
5 жыл бұрын
Can you help me I'm stuck I have about 500 people in excel and I need a macro to import and batch process there name and address into a word doc that has a table inside it. It would need to create 1 word doc for each person. in excel it would take info from Name and address.
@KrishSanj
5 жыл бұрын
I have videos specifically for this please check. If you still need help let know
@fabiantocanchon
2 жыл бұрын
I already downloaded the files to replicate the scenario. However when I run the script nothing happens, no errors, no results… any idea Why? Thanks in advance!
@naimakhebbache5742
9 ай бұрын
this means that it works, you just need to click on the Finish and Merge icon and your report will be created
@calebhoch2563
6 жыл бұрын
@Krish Sanj Do you know to make set this for a table? Basically, I have a table in Excel that varies in the amount of rows. The columns never change, but the data in the rows will change often. How can I make this so that it will take the data from excel and make a table in word with the same number of Rows?
@KrishSanj
6 жыл бұрын
will have to write VBA code, seems straight forward. Try if you have knowledge on that . Let me know if you were able to.
@calebhoch2563
6 жыл бұрын
I do not have a lot of experience with it, but will see what I can do. Thanks for the reply. Any pointers on where to begin with it?
@KrishSanj
6 жыл бұрын
Caleb Hoch best way to learn is to record a macro and edit. But your situation will require bit more effort
@angelomonopoliroca523
2 жыл бұрын
Hi i am having some troubles while runing the macro. "type not corresponding" in italian: "tipo non corrispondente" I have my documents saved in the cloud, do you think that might be an issue? Here is my code: Sub getdata() Dim numRecord As Integer Dim myName As String myName = InputBox("Enter de Value!") Set dsMain = ActiveDocument.MailMerge.DataSource If dsMain.FindRecord(FindText! = myName, Field! = "Name") = True Then numRecord = dsMain.ActiveRecord End If End Sub
@jamesknight9460
5 жыл бұрын
This is good but how do you make it search for numbers rather than text. for example if there are numbers in the name column of the excel file then the script wont find them
@KrishSanj
5 жыл бұрын
it does not matter, what is your case? Give more details so that I can take a look
@jamesknight9460
5 жыл бұрын
@@KrishSanj you're right it works with numbers, the problem it seems was some bug because the code only does a forward search of records so it doesn't look back: stackoverflow.com/questions/47364511/vba-macros-not-working-correctly/47364911#47364911?newreg=6d40bb18d44d4c77bd62c5cf3704c9a3
@emiraufbjk
6 жыл бұрын
Thanks for the video and usefull all informations Krish. In my pc when i try to run the macro it gives run time 13 error. I am office 2016/office 365 user. Do you have any idea what is the problem? and How can i fix it? thanks anway.
@KrishSanj
6 жыл бұрын
can you gimme the actual error msg
@emiraufbjk
6 жыл бұрын
Run-time error '13' : Type mismatch
@KrishSanj
6 жыл бұрын
Emir Gökbudak it's a data type mismatch. try to use numbers instead of string
@emiraufbjk
6 жыл бұрын
Actually i tried "Long" but result is same unfortunately. Could you tell me which boxes are choosen in your VBA references?
@emiraufbjk
6 жыл бұрын
Could you tell me which boxes are choosen in your VBA references?
@soniaalalwanii
3 жыл бұрын
I have tried multiple times but am not getting the same result after running the code. It still remains blank. Can you help
@KrishSanj
3 жыл бұрын
let me know exact issue
@samanthathomas3737
3 жыл бұрын
Can you please share the macro? Or direct me to one of your other videos that explains how to create it? Thank you!
@KrishSanj
3 жыл бұрын
Didn't you find that in the description ?
@samanthathomas3737
3 жыл бұрын
@@KrishSanj I see the google drive link...? Is it in the paper slip form document? I downloaded the document and went into the Macros under Developer and nothing is there.
@samanthathomas3737
3 жыл бұрын
@@KrishSanj Let me know if I'm over looking something!
@reforesting
3 жыл бұрын
@@samanthathomas3737 Did you found it?
@samanthathomas3737
3 жыл бұрын
@@reforesting No! Did you have any luck? If so, please advise!
@reforesting
3 жыл бұрын
Awesome tutorial! The downloaded files do not show the code, but copying it is enough. Thanks for sharing
@jonashoffmann3008
7 жыл бұрын
Hallo. unfortunately the vba code shown in the video doesnt work. can u post the correct code?
@SgtMao
4 жыл бұрын
Thank you for this tutorial, really helped me save time writing my invoices. keep it up
@danyosuna7276
4 жыл бұрын
Is there a way to generate different documents for each row in the excel automatically? Lets say I want to create the documents of ALL the people on the excel using the same macros, is there a way to do it?
@LMC5280
3 жыл бұрын
I am looking for the same. Did you find out how?
@sarahlyoliiveros9492
Жыл бұрын
I am looking for the same thing 😢
@danyosuna7276
Жыл бұрын
@@sarahlyoliiveros9492 i AM sorry:( But I did quit so it turned out okay
@Ashis.7_
Жыл бұрын
This video was help full from me in critical seatution
@szypekwsp
5 жыл бұрын
Does not work! When typing the name and pressing OK, nothing happens, but when doing preview only, everything works fine. Could anybody help?
@husseincharif5683
5 жыл бұрын
i have the same problem .did you find a solution for this ?
@veerabhadram9252
6 жыл бұрын
Enter the value - we are typing as IFGI-NAM-P0001 ,2,3,4,5,6 etc.., (which we created in the excel sheet) we given column name as"post record".please guide us
@veerabhadram9252
6 жыл бұрын
please provide macro program
@KrishSanj
6 жыл бұрын
More similar videos: kzitem.info?o=U&video_id=zmAQa-cqQp0
@naiduinfo
5 жыл бұрын
Is it publish in a website for all details published in documents
@KrishSanj
5 жыл бұрын
Check my site
@GauravGupta19
6 жыл бұрын
The dogs barking in the back makes the video even more interesting.
@SimSelena
6 жыл бұрын
hello I have a problem with the Macro setting. Error message: Compile error: End If without block If Could you help me to find the problem?
@SimSelena
6 жыл бұрын
Sub getdata() Dim numRecord As Integer Dim myDealer As String myDealer = InputBox("Enter the value:") Set dsMain = ActiveDocument.MailMerge.DataSource If dsMain.FindRecord(FindText:="myDealer", Field:="Dealer") = True Then numRecord = dsMain.ActiveRecord End If End Sub
@KrishSanj
6 жыл бұрын
Have you copied the code properly ?
@SimSelena
6 жыл бұрын
the only difference is (FindText:="myDealer" instead of (FindText:"myDealer
@emceeb5289
3 жыл бұрын
@@SimSelena I think you need to add a space on the top side, in that way the code works for me
@captainchinar
4 жыл бұрын
The Macro does not seem to work. What am I doing wrong?
@KrishSanj
4 жыл бұрын
what is the issue error
@captainchinar
4 жыл бұрын
Krishna S Saya the expected error. The opening bracket before the string Name is extra. Also when I run the macro, the result does not get populated on automatically
@mudasirshora77
7 жыл бұрын
Nice one. Could you please help me .I want to copy entire excel page and fit in into one word page without overlapping
@KrishSanj
7 жыл бұрын
you mean the entire excel columns? thats around 16000 + columns?
@mudasirshora77
7 жыл бұрын
No, i have a excel page say 50 columns and its not fitting in word
@KrishSanj
7 жыл бұрын
you can adjust the column size rt? what is your problem exactly ?
@mudasirshora77
7 жыл бұрын
once i paste in word, its is out of page margins
@KrishSanj
7 жыл бұрын
If the content beyond the width of the MS word page, then it will go outside margin. Set the page margins and indentation so that it will be wrap to next line
@walidnazmifordigitization5204
3 жыл бұрын
Awesome, the serves the purpose of my life
@abdulhamidalhaddadi2255
2 жыл бұрын
Great job sir. Thank you
@sAlch-42-10n
2 жыл бұрын
Thanks for the video bro, it helped me a lot! straighforward and clear explanation!
@anilsah5709
5 жыл бұрын
Mai chahata hu ki ek aiasa table (form) banau jiseme details bharne ke bad word ki document me ek letter ki tarah likha jaye jo mail merge ki tarah hi ho kintu yane ki kisi ko loan dete samay pura biwran bar bar bharna na pare sirf form bharne se mera data tayar ho jaye aur use print kar saku.
@emceeb5289
3 жыл бұрын
I hope someone helps me, the macro code is not showing when i click the VBA.
@KrishSanj
3 жыл бұрын
you need to enable developer mode for that. check my other videos for that
@emceeb5289
3 жыл бұрын
@@KrishSanj Macro doenst work for me, what could be the possible reason? I try using a unique set of code which is in the first column, but the following data are not changing
@emceeb5289
3 жыл бұрын
@@KrishSanj The first row in the data kepts showing, then when I undo it the second row data is showing.
@ishratkhan1746
5 жыл бұрын
I can't read the code, can someone please copy paste here:)?
@gubluuk7539
7 жыл бұрын
1.sir is there any way to generate doc file from the details of excel data ... like this COMPANY NAME 3 copies for 3 individual employee 2.How to generate a single COMPANY NAME doc with details of all the individual employee present in the employee. xls instead of asking the employee name in the prompt box
@KrishSanj
7 жыл бұрын
check other videos on my channel. let me know if you still need help
@gubluuk7539
7 жыл бұрын
Krish Sanj Sir it will be very helpful if you please post me the link of video related to my queries. this video is very much helpful even the video related to bookmark. thanks in advance
@MikeCarey101
5 жыл бұрын
awesome video- exactly what i was looking for and explained very well. thank you
@cezarymaciejewski7509
5 жыл бұрын
How can I generate such thing automatically for many people? ;)
@walter_ribeiro
5 жыл бұрын
That's what I am looking for!
@omnia9348
5 жыл бұрын
@@walter_ribeiro two
@sanketpande
5 жыл бұрын
I want the following help with automation of daily incident report . 1. To create a daily report in word format, based on inputs for different locations/regions/districts, classified as types of incidents. 2. Alternatively suggest means to populate an excel sheet from a daily incident report in word document, for purpose of analysis.
@KrishSanj
5 жыл бұрын
You need to write a sophisticated vba code to extract info from daily reports. What is the format of a daily report? if it is in text format then it is easy. check out my other videos which are useful. Let me know if you need further help
@rajagopalan9043
6 жыл бұрын
Post a video for how to do get the data by macro automatically from excel to word help of vba.
@sheldonrunkey6160
5 жыл бұрын
utilize the same macro function he had above, but put it into the "This Document" area so it runs when the document opens. You can also use excel vba to open the word document which should eliminate the "Enable Macro's" Pop-up.
@lewismckenzie7266
6 жыл бұрын
Very helpful! Saved me hours of work. Thank you Krish
@ryybuu
6 жыл бұрын
The macro isn't working for me. There's no errors the information just simply doesn't appear in the word document.
@KrishSanj
6 жыл бұрын
try enabling macros in the security settings. see my channel for videos on how to enable macros. let me know if you still have issue
@KrishSanj
6 жыл бұрын
what version of office are you using?
@ryybuu
6 жыл бұрын
I'm using the same version as you. I found a different way of doing it, without macros.
@SimSelena
6 жыл бұрын
Can you tell me the other version that you found? or any link if you have. Thanks in advance
@zeeshankhatib7776
6 жыл бұрын
@@ryybuu hi, can you share the alternate method
@drishtidhole9888
4 жыл бұрын
click macro buttin to make the macro before developer button
@hajarjoulal257
4 жыл бұрын
thank you so much. this is exactly what I was looking for
@bishwarup990
7 жыл бұрын
The macro is unable to find previous any previous name from the Names field
@KrishSanj
7 жыл бұрын
recreate every on a fresh copy of excel
@bishwarup990
7 жыл бұрын
Sorry didn't get you. I have followed all the steps that you have shown. The macro is able to retrieve records if the record comes from top to bottom of the excel sheet. However any record which is above the current retrieved record is not getting fetched. Its really a trouble. Could you please help.
@KrishSanj
7 жыл бұрын
I will check and update in couple of days. Thanks for you feedback
@tajsindhu
6 жыл бұрын
Thanks Krish.. Great video.. Just like @Truth it took me a few video to see this.. (The time 4:55 VB code stopped with debug in my case.)
@HUNmotyon
2 жыл бұрын
Not working of course. All should be different files with different names.
@KrishSanj
2 жыл бұрын
let me knwo what is your issue
@soniaalalwanii
3 жыл бұрын
Can you please give me the VBA code
@KrishSanj
3 жыл бұрын
Link in the description, check and let me know
@raghavaa9975
6 жыл бұрын
Hai Sir...is there any possibility to populate specific values from excel and put them in specific locations in the word file automatically. Please share your mail id so that i can share my data to you to know the possibility.
@KrishSanj
6 жыл бұрын
Ragava Alamuru there videos on my channel which explains this. check the. out if you still need help let me know
@juulsilverenberg1216
6 жыл бұрын
I have a similar problem. I want specific cell values to be inserted in the middle of a sentence. For example: The value of the measurement is "Cell A1" which means that... So the value is written down in excel and I want to convert it to a report in word.. I found a way, but maybe you know a better way. The problem I have at the moment is that the sentences made in a cell in excel wont have a page break in word... I couldnt find the video you mentioned
@williampalmer2666
7 жыл бұрын
How do I create the Macro
@KrishSanj
7 жыл бұрын
William Palmer please check out my channel for macros
@ThiagoPrego
4 жыл бұрын
Thank you very much. May Jesus bless you.
@oldman28guy18
6 жыл бұрын
This tutorial was legit. Thank you!
@KrishSanj
6 жыл бұрын
Glad it helped you. Share it
@submissionjobs5642
4 жыл бұрын
Where is the code?
@thebesttechnical3608
5 жыл бұрын
Supper explanation and very helpful
@nikyabo8326
4 жыл бұрын
My mailing only shows F1 F2 F3 F4 no actual fields
@KrishSanj
4 жыл бұрын
It's possible that you have missed something.. please do it again
@chiranjibiupadhaya7160
5 жыл бұрын
How to create a macro?
@bishwarup990
7 жыл бұрын
The macro is not working
@KrishSanj
7 жыл бұрын
What is the error ? Try changing the macro security.
@ahmedsaleh8634
3 жыл бұрын
Nope, waste of time. The macro isnt even included anywhere in the file nor on this page. So called "solution" doesnt work without the macro.
@RaviVerma-dx6wr
6 жыл бұрын
how to solve this decimal problem from over numbers
@KrishSanj
6 жыл бұрын
Ravi Verma what's the issue
@mettaleecixin
6 жыл бұрын
You can convert the decimals to text with the text function. Then extract the text format of the values from the excel sheet, instead of the number format
@KrishSanj
6 жыл бұрын
Metta Lee text function is format anything as text. Say of you want to print 00012, u have to use text. Of you simply type 00012 it will take it as 12 try that
@MrHemant60
5 жыл бұрын
@@mettaleecixin not working
@rebecaberenice3375
4 жыл бұрын
The most important part of the video is blurred!
@gauravtimalsina9511
6 жыл бұрын
thanks man. This is the exact thing I was looking for[
@syrasolarsolarenergy1242
6 жыл бұрын
Excelent video! Helped me a lot!
@nagab797
5 жыл бұрын
Hi bro please send me the code if you have
@dildilpakistan824
5 жыл бұрын
wow very good informative video keep it up
@adhil56
4 жыл бұрын
It is not working
@lucianobottoni2360
6 жыл бұрын
Really thanks!! just what I need!
@KrishSanj
6 жыл бұрын
Glad it helped. Please check out other similar videos. Also, let me know what kind of videos you are expecting in office automation.
@antarboua1988
7 жыл бұрын
thank man you are a life saver!!!
@funkydeea
7 жыл бұрын
The macro does not work....
@KrishSanj
7 жыл бұрын
what is the issue. What error are you facing ?
@funkydeea
7 жыл бұрын
Compile error: Sub or Function not defined
@funkydeea
7 жыл бұрын
I just copied everything that you posted as is
@KrishSanj
7 жыл бұрын
Andreea Szabo the error clearly sub is missing. try again a the steps
@MrParkjhyuk
7 жыл бұрын
Hi. I also same issue, It does not find out the datasource in macro. how to solve it? Thank you for your video.
@r6642
4 жыл бұрын
Not working g
@felipecrespilho1158
4 жыл бұрын
NFS fixed int the taskbar hahaha!
@alef6179
6 жыл бұрын
Thanks! very helpful!
@KrishSanj
6 жыл бұрын
Glad it helped. Please check out other similar videos. Also, let me know what kind of videos you are expecting in office automation.
@sondoskannous3306
6 жыл бұрын
thanks, Its perfect!!!
@arupchetia8974
5 жыл бұрын
bhai tu desi hai ya videshi hai ?????????/
@MichalSada
4 жыл бұрын
thx mate
@4ur3n
5 жыл бұрын
nice video :)
@Apragoc
4 жыл бұрын
thank u, subsribed
@KrishSanj
6 жыл бұрын
kzitem.info/news/bejne/pYqo0Y5jmmZmoI4 Beautiful grpah using conditional formatting
@alvinmadathil
5 жыл бұрын
Instructions were inaccurate and misleading, please take a look at your Macro code and look at how you've spelled "Name" in Dim myName on the 3rd line as well as "Value" on the 4th line.
@KrishSanj
5 жыл бұрын
Let me check that thanks for the feedback. It helps many
Пікірлер: 213