Excellent tutorial, quick question... what if I need to have a field empty in the Word document ? what code should I use in VBA
@menaabdonasry
4 жыл бұрын
Thanks Very much for the informative valuable illustration. It helped me a lot.
@selvan1264
2 жыл бұрын
Thank you for the video :) Wonder how to include different attachments for different emails using this code?
@RISK360NLP_NNT_AI
Жыл бұрын
Really Your super Hero of VBA 🙏🙏😎😎🔥🔥
@xtremeExcel
Жыл бұрын
So nice of you
@Rizwan1875
3 жыл бұрын
You have explained it brilliantly! I have one query on this: In my case I am putting a very large table in the mail body and during macro execution Outlook is getting hanged and thus macro stops working. My code is working fine when I put a small table or text. Please suggest me how I can resolve this issue. Thanks.
@neilh4729
11 ай бұрын
Thanks, great video. Is there any way to send the emails without having to display each one first?
@RakeshKolla
4 жыл бұрын
It is Awesome, I love it. Sir is there a chance we can attach/embed the word file in excel itself and use it as one file?
@rthomas268
Жыл бұрын
I am thinking that this will work for a Word document that is not a template that is sent to several emails with individualized attachments?
@lionelcarassic7338
4 жыл бұрын
Dear Kamal, Thank you for your clear and simple video. It helps me a lot in my work ! Just one question : In my Word template I have a blank line inserted between each line : Line 1 Line 2 Line 3 But in the mail, there is no more blank lines : Line 1 Line 2 Line 3 Could you tell me why ?
@nageshsunkara82
3 жыл бұрын
Hi. It's very good. But pls confirm if it is same as mail merge.
@bilgehankavlak5330
3 жыл бұрын
Very useful. Thanks for sharing. Keep going!
@xtremeExcel
3 жыл бұрын
Thanks mate..Keep sharing and stay connected !
@roshanrafik
2 жыл бұрын
Thanks for the video its helped.. i have tested two cases. however, first row data i mean employee A data is capturing for employee B. Also, is there any way i can add the table if single employee having more line items ?
@neetudhillon1565
3 жыл бұрын
Hi, I'm getting some errors. I'm really new to VBA 1. Variable r not defined, how to define that. 2. I need to add few attachment to the code
@noorbisharmohamed
2 жыл бұрын
Thanks for the explanation. By exactly following your steps, I have developed a tool that can automate. But I found it challenging that if I want add a link to my email where the hyperlink is stored in worksheet. range (1, 6), it only pasts a text (the hyperlink text) in the email body? Please assist how can copy this link to the word doc and then pasted to my email.
@johnabram4159
3 жыл бұрын
Thanks. I have been looking for this long time. Could you please also explain on how to find and replace images in Word editor similarly. Like, if we want to include image of the employee as well. Given that images of all employees are saved in a folder as JPGs with filename = employee name or ID?
@BuiQuynhNhu
Жыл бұрын
It is brilliant!! Thank you!
@xtremeExcel
Жыл бұрын
Glad you like it!
@gstcompliance1502
2 жыл бұрын
It is awesome. Working fine.Thanks
@aramac
3 жыл бұрын
Great video. The macro works fine on the first loop but on the second it appears an error message in < Set doc = Documents.Open(Range("B2").Value)">. Do you know why this might happen and how to fix it?. Thank you very much.
@xtremeExcel
3 жыл бұрын
Can you share your file please?
@risky9356
3 жыл бұрын
Nice Video! Very useful. How to put clickable hyperlinks in one of the Value that changes as other Values change as well?
@himangshughosh6743
3 жыл бұрын
Kamal, This is working absolutely fine; however, I want to send from my shared mailbox and upon using .sentOnBehalfOfName It's not working. Could you please make a video on this please
@melva1764
3 жыл бұрын
Great video! Is there a way of applying only to filtered rows?
@madhusudan2u
4 жыл бұрын
Very well explained, thank you 👌
@xtremeExcel
4 жыл бұрын
Glad it was helpful!:-)
@kmitu5635
4 жыл бұрын
Hi Kamal, could you post your code in the secription or a publicly accessible google doc?
@letslearnexcel
4 жыл бұрын
Hi! Thank you for this video. It was really helpful. I have a question here. How to avoid the outlook security alert message?
@xtremeExcel
4 жыл бұрын
In outlook settings you need to enable programming access..
@letslearnexcel
4 жыл бұрын
Extreme Automation - Kamal Girdher. Is there is any other options to do this thru vba since I don’t have this access in my company to change the outlook alert settings?
@xtremeExcel
4 жыл бұрын
No other way.
@guillaumepaquet1551
Жыл бұрын
Great explanations!!!
@xtremeExcel
Жыл бұрын
Thanks!
@sajinifaby
3 жыл бұрын
Thanks for sharing your knowledge..its great help!!
@xtremeExcel
3 жыл бұрын
Stay connected!
@ZillaVKong
4 жыл бұрын
This is great information. Where can I find a copy of this code? Please provide link to download.
@jesusprince2569
3 жыл бұрын
i guess it is kinda off topic but do anybody know a good website to stream new series online ?
@jesusprince2569
3 жыл бұрын
@Harvey Amari Thanks, signed up and it seems to work =) I really appreciate it!!
@harveyamari1815
3 жыл бұрын
@Jesus Prince Happy to help =)
@dheerajthakur2960
3 жыл бұрын
Hi. Could you please advise how to send internal email only. Actually, I want to automate bulk email in my organization outlook that microsoft Azur classification. Could you please advise how to automate this before send email
@enjoypeace5120
2 жыл бұрын
Hi, I am having error of variable not defined for "For r = 5 To Sheet1.Cells(Rows.Count, 1).End(xlUp).Row", can please advise?
@mawwww88
2 жыл бұрын
same!! please help
@ashwinishinde4524
4 жыл бұрын
Could you please advise is it possible to add different word document to user as specific criteria
@dinacarella3531
Жыл бұрын
This was so helpful. Can you show how the email outlook signature be applied as well. Signature does not show.
@dinacarella3531
Жыл бұрын
I figured it out. So simple all I had to do is copy my outlook signature & paste it to the word document.
@xtremeExcel
Жыл бұрын
glad you figured it out.
@gregoryslack7116
3 жыл бұрын
is there a way to to send it only to visible rows? I want to be able to filter rows and then send the email?
@j.dasilva4567
2 жыл бұрын
Can u make this without opening the word doc, meaning, work in the doc editor inside the email body?
@neilwalker3204
3 жыл бұрын
An excellent tutorial, thanks for posting this.
@ankushgupta6598
4 жыл бұрын
Hello Kamal, Thanks for this video I have tried to make tool with your coding and it works perfectly But my word application is not closing . Let say if i have 5 names then it is showing five word application open Please let me know if you have solution for this as well Thanks Again
@xtremeExcel
4 жыл бұрын
can you send me your file please?
@risky9356
3 жыл бұрын
Same issue for me as well
@reiniersilo6044
2 жыл бұрын
is this issue resolved?
@jazzzyymmm
4 жыл бұрын
Life / work saver!!!! 👏🏼
@ravi2191990
2 жыл бұрын
Sir, Thank you so much, but here 1 error shows (error object variable or with block variable not set) is it shows due to we did not define workbook? Plz answer
@xtremeExcel
2 жыл бұрын
send your file to me please.
@1Proxicus
3 жыл бұрын
Some of the text I want to copy over exceeds the 255 character limit, any suggestion ideas ?
@sangeetagujaran8372
3 жыл бұрын
This is very helpful. Thanks a lot But I m getting a dialog box saying "do you want to keep the last item you copied" I want to send it to 100 ppl hence 100 times the dialog box is occurring Can we give some command in VBA for this dialog box ??
@xtremeExcel
3 жыл бұрын
If you see an alert in excel then use Application.DisplayAlerts=False Before you copy And Application.DisplayAlerts =True after you paste or close the file.
@RajeshKumar-uu5hz
3 жыл бұрын
Hi Kamal, I am new subscriber and I found this video is very useful. Related to this query actually many Word file is opening with this comment. Can you please provide the resolve code. Thank you.
@angelicavaldez4675
3 жыл бұрын
I tried running the code but I got "Error 5097" which points here: Set Editor = .GetInspector.WordEditor Editor.Content.Paste what could be the problem? I'm new to VBA please help
@abhishekvishwakarma3860
3 жыл бұрын
Yes, this code was working fine but from couple of days I am also getting same error. Kamal Sir- your support pl.
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@ShaKaKaStudios
2 жыл бұрын
How would you have it open a specific word template for each row?
@sams9329
4 жыл бұрын
Can we send all employee performance data of the email body in the form of a picture with its name and performance number
@lok93919
4 жыл бұрын
i come across with many reference on the internet but yet cant find one appropriate....wanna see if you could help.....my situation is: i want to have a dynamic subject for my mail merge, in which i've obtained which work for me already....but i cant find one that i could cc some one. I'm using the mail merge function in word with data in excel, what i'm looking for is: when i complete the mail merge, the each email will be sent e.g. "TO: email_A; CC: email_B,C...." is that possible to write a vba code to make it happen in word?
@lok93919
4 жыл бұрын
Or, in alternative, by following yours, possible to run a dynamic subject like "SUBJECT LINE - No.XXX" where XXX is the string i want to be different in each mail.....
@uday_ch
4 жыл бұрын
Thanks. Please help me in how to find and replace words within Textbook in word.
@manjeetpatel0088
4 жыл бұрын
It helped a lot. Thank you very much :)
@Pankaj-Verma-
3 жыл бұрын
Thank you so much for your kind help.
@xtremeExcel
3 жыл бұрын
Sure. Please share this content in your network👍
@tranthihaiau2839
4 жыл бұрын
Hello Ad! It's really helpful! But I could not see the "Getlnspector.WordEditor" in my computer. Where could I get it? Do I need to download or addin? Thank you so much!
@tranthihaiau2839
4 жыл бұрын
I did again. It's not bad. But there is the notice 'Do you want to save the last copy of ....If yes it might take a bit longer to close. How to stop this pls?
@amiramansour1908
3 жыл бұрын
Hi Kamal i want to buy the Macro but adding delay function how much you will charge me?
@melissaaguirre3193
2 жыл бұрын
for some reason when trying to open the word doc it doesn't open, it only opens the word app but then it stays gray with no document opening, do you know why?
@rahulkatkar7884
4 жыл бұрын
Sir, I'm getting as variable not defined for Editor and content. Can u plz help me to know the error. Set editor=.getinspector.wordeditor Editor.content.paste
@bobbyyorba2610
3 жыл бұрын
Hi, did you ever find a solution for this? My macro fails and debug takes me to 'Editor.Content.Paste'.
@wschultz1000
3 жыл бұрын
@@bobbyyorba2610 Did you find a solution. I'm stuck as well.
@murkuttogaming
3 ай бұрын
Sir how to make such template to attached on mail rather than on mail body and send automail on emails
@thangns8852
Жыл бұрын
Great!
@riddipress526
4 жыл бұрын
I'm getting only one Mail Item while Running this ! and the"Doc.Content.Copy" Code is not working Could you help me to Fix it
@abhideepramnagariya4482
3 жыл бұрын
How to assign special tabel i.e different different tables in the email draft for different different recipients.
@Singwithneeraj
2 жыл бұрын
Hi Sir, this coding is very helpful for me but I am facing issue in getinspector section All things ok but nothing shows in mail body .. please hlp sir...🙏🏼
@xtremeExcel
2 жыл бұрын
Hi Neeraj, Please share your file so that I can check.
@balajir171
2 жыл бұрын
Any update on the getinspector error?. I'm badly stuck due to that issue.
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@vamsikrishna2969
Жыл бұрын
Hi, how to use word template as email reply based on subject line?
@mohitsahu203
4 жыл бұрын
Sir my word file in open to copy the content but its not close automatically. It shows copy to clipboard yes or no. Why this happen and how to solve this please tell
@wschultz1000
3 жыл бұрын
Where can I find the code? This looks great but I cannot locate the code. Thanks.
@shivanand9858
3 жыл бұрын
if we have three different data send email to one person... instead of sending 3 emails i want to send one email with all three data to same in excel format
@RaduV1692
2 жыл бұрын
Hi. I am one of the guys which is having the error runtime 5097, Word has encountered a problem. After several checks I understand the reason of this error are some Windows updates. While trying to debug, I am pointed to Editor.Content.Paste . Is there an alternative in the code to avoid this error ? It was working perfectly until the Windows Updates. Maybe some registries are affected because of this.
@xtremeExcel
2 жыл бұрын
Please send me the file and share details of where exactly you are facing the issue. I do not have these files handy with me. It would be easy for me to look into the issue if you can share the file exactly like where you are facing the issue.
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@rajvenkat3641
4 жыл бұрын
Sir, if I wants to use same word document and not dynamic like your explanation at which step I can stop coding as per your script
@xtremeExcel
4 жыл бұрын
In that cases you should not use word template. You should draft the email in outlook and save it as outlook template. Then while creating new item you should use CreateItemFromTemplate instead of CreateItem function.
@pascallink9207
2 жыл бұрын
How to replace text in this word document by a hyperlink (excel range) to a website or mailto-address with vba?
@cpkanojiya
3 жыл бұрын
Get Error Editor Variable not define Set Editor = .GetInspector.WordEditor Editor.Content.Paste How can define and resolve this error.
@ericaboseroy4718
3 жыл бұрын
this is happening for me also. sir, can you please give the solution.
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@ketanghadge5858
3 жыл бұрын
Getting error For r = 5 to select. Cells(rows.count,1).end(xlup).row getting run time error 424 object required
@MandeepSingh-uf4cj
4 жыл бұрын
I created using same and while I am displaying it and it is working perfectly but when I am trying to send then it's sending but blank email with correct subject..
@arundev9239
4 жыл бұрын
@Mandeep Puri same issue im facing. Please help to solve
@xtremeExcel
4 жыл бұрын
Please send your file to me.
@arundev9239
4 жыл бұрын
@@xtremeExcel mail has been sent to excel.microk@gmail.com please help to solve this issue
@balajivijayakumar803
2 жыл бұрын
in that email body, how to add hyperlink word doc. for specific line or end of line
@khushraaz19310
3 жыл бұрын
Sir it's was easy for your all subscriber nd viewer if you will provide code link or xlm link, than you, waiting for ur answer
@khushraaz19310
3 жыл бұрын
Please provide us file link, thankyou sir
@lilyfullery4779
Жыл бұрын
A big thank u ❤
@abhishekvishwakarma3860
4 жыл бұрын
Gr8, would be very helpful for learner if attach practice workbook
@xtremeExcel
4 жыл бұрын
I suggest you to follow this playlist. I have shared link to github repo with all code snippets and documentation. Excel VBA - Outlook Automation | Bulk EMAILS: kzitem.info/door/PL1R_HJw0CDYKtGsYLUXyC_qvEgKZ7kb2N
How to attachment the Word or pdf document with the same coding
@meherasees1790
3 жыл бұрын
What if the data has links also how to add that to template
@wweindiahighlights
3 жыл бұрын
How can i send it from my group email id. I don't want it to send it on my personal id
@meherasees1790
3 жыл бұрын
I am getting error for GetInspector method I have added all the add-in references but unable to run the code
@neenageorge7533
2 жыл бұрын
any other code for attaching the attachment with word template
@sadinenim5360
2 жыл бұрын
what if i want to connect hyperlink in cell to a name in word document. sir can you please help me.
@xtremeExcel
2 жыл бұрын
name in word document means?
@noorbisharmohamed
2 жыл бұрын
@@xtremeExcel I think I have the same problem. Firstly I appreciate your explanation on the subject. By exactly following your steps, I have developed a tool that can automate. But I found it challenging that if I want add a link to my email where the hyperlink is stored in worksheet. range (1, 6), it only pasts a text (the hyperlink text) in the email body? Please assist how can copy this link to the word doc and then pasted to my email.
@ck2768
4 жыл бұрын
Dear Kamal Sir, would like to bring in your notice that the code is displaying all the emails but not sending the emails. Request you to please do check and rectify the problem occurred.
@xtremeExcel
4 жыл бұрын
Instead of .Display if you use .Send, it will send the emails
@ck2768
4 жыл бұрын
Dear Sir, Thank you very much for your reply. If I use .Send, then the outlook is sending the email but not pasting the the content of Word template in the mail body of outlook. If I use .Display, then the outlook is pasting the content of Word template in the mail body of the outlook. Exactly this the problem.
@xtremeExcel
4 жыл бұрын
Use.Display first, then paste the content, then use .Send
@osamashaheen7396
Ай бұрын
Could you please provide the code here so we can copy it ?
@vishalgandhi4279
3 жыл бұрын
if we have table and graph than how can we add
@kishoresaib5207
3 жыл бұрын
.getinspector.wordeditor is throwing an error stating "operation failed". Working fine for display not for sending.
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@anilkumar-rm9wu
4 жыл бұрын
Few lines giving me error: Set olm = ol.CreateItem(olMailItem) Set wd = New Word.Application but instead if i am changing it to Set oa = CreateObject("Outlook.Application") Set olm = oa.CreateItem(0) Set wd = CreateObject("Word.Application"). it is opening word, but not giving the result, Also i am getting error for below lines Set editor = .GetInspector.WordEditor WordEditor.Content.Paste Please help
@xtremeExcel
4 жыл бұрын
Hello Anil. Please send your file(having code) so that I can debug and tell you the issue.
@anilkumar-rm9wu
4 жыл бұрын
@@xtremeExcel Have rectified all the errors. Now getting error on Set editor = .GetInspector.WordEditor and i am using office 16. is it because of some compatible issues?
@riddipress526
4 жыл бұрын
I'm Getting the Same issue Here, and i Troubleshoot that Compatibility Issue again i'm getting the same Error
@Malape1997
4 жыл бұрын
I'm also experiencing an error with "Set Editor =". Have you guys identified the challenge?
@riddipress526
4 жыл бұрын
@@Malape1997 declare the editor variable it will work perfectly !
@sriramansethu
3 жыл бұрын
Close. Savechanges= false is not working...
@sadinenim5360
2 жыл бұрын
And also I have found something challenging i am facing difficulty when I need to paste a word document with formatting as it as mail body
@xtremeExcel
2 жыл бұрын
for that you need to use htmlbody instead of body
@mahathmasadineni2884
3 жыл бұрын
can you please share that workbook with us.
@bhartimittal6513
2 жыл бұрын
Is there anyway that we can attach pdf also
@xtremeExcel
2 жыл бұрын
yeah. we can attach any file type.
@rsilo718
2 жыл бұрын
.send is not working but the display works
@xtremeExcel
2 жыл бұрын
What error are you getting?
@AnujGupta-hf1if
4 жыл бұрын
Sir Please create VBA program in outlook developer also.
@xtremeExcel
4 жыл бұрын
Sure. Thanks for the suggestion.
@amjadsk2662
4 жыл бұрын
Object variable or with block variable not set ... Run time error 91 In VBA script. With wd.selection.find Please advise to proper run
@shubhammishra6694
3 жыл бұрын
Hey! did you ever find a solution to this? Getting the same error.
@shubhammishra6694
3 жыл бұрын
Fixed 2 issues in my code: 1.) was using .doc in filepath when my file was.docx 2.) Declared Editor as Word.Document
@kamathandkamath1581
2 ай бұрын
@shubhammishra6694 please assist by giving the code line
@SatyaPrakash-qy4oy
2 жыл бұрын
Need a vba code for editing subject line as well.
@xtremeExcel
2 жыл бұрын
very easy. just put .subject = "" in the with block.
@ManojYadav-nt2rm
3 жыл бұрын
signature alignment is not correct.though nice video thanks
@uday_ch
4 жыл бұрын
Error occurred invalid =. GetInspector.WordEditor
@kamathandkamath1581
2 ай бұрын
Please assist on how to resolve this. I am getting same error
@sudhakarshankar5085
2 жыл бұрын
How to add CC?
@geovannysolano
2 жыл бұрын
In the part when adding the email subject and topic, add one line that says: .CC = "TheNameOfYourWorkSheet".Cells(r, "Column#WhereCCEmailsAre".value Replace the information within quotation marks with your information.
@amreid5680
2 жыл бұрын
Hello bro would you please send code ?
@xtremeExcel
2 жыл бұрын
Sorry I do not have the file handy with me. In case you are facing challenge in the code explained in the video, please send that file to me. And I'll check why it is not working for you.
@amreid5680
2 жыл бұрын
@@xtremeExcel I'd like to add attached in the mail would you please help me ?
@amreid5680
2 жыл бұрын
@@xtremeExcel Dear i want to remove Display and send email Automatic and add attachment
@neenageorge7533
2 жыл бұрын
Compile error :Wrong number or arguments not properly assigned
@xtremeExcel
2 жыл бұрын
please send your file to me. Details are on channel homepage.
@somyiori667
Жыл бұрын
not working :(🤔
@xtremeExcel
Жыл бұрын
what's the issue?
@MK-vj8md
Жыл бұрын
@xtremeExcel Hi , it gave error Run-time error '5174' Application-defined or object-defined error Using MS Office 2019
@Hanan_athaya
6 ай бұрын
T
@geovannysolano
2 жыл бұрын
Hi Kamal, Firstly, excellent solution. It has helped me a lot! I do have one question, though: one of my replacments are dollars and I would like to have this formatting. The template already has this coded, I have it as: {$«Amount_to_Factor» \# ,0.00} but when I run the wd.selection.find and .replacement.text it is giving me the number without the formatting. I tried to add the number format at the end like this: .replacement.text=activesheet.cells(r,27).value.NumberFormat = "_($*#,##0.00_);_($*(#,##0.00);_($*""_""??_);_(@_)" but is giving me an error. Any ideas? Again, thanks a lot for the knowledge sharing. It has been very enlightening
@neilh4729
11 ай бұрын
You've probably found a solution by now, but if anyone else has the same is try using .Replacement.Text = Format(ActiveSheet.Cells(r, 27).Value, "$#,###.00")
Пікірлер: 181