- 3
- 436 204
Imnoss
United Kingdom
เข้าร่วมเมื่อ 8 ธ.ค. 2020
Tips and tricks to help you systematise/automate your work using the tools you have from Excel through to the Microsoft Power Platform.
Imnoss - How we help you!
Imnoss - enhancing your digital transformation through better use of the tools you already have
มุมมอง: 836
วีดีโอ
Mail Merge to Email with Custom Subject, Attachments, Save to Drafts and more - No Plugin!
มุมมอง 157K3 ปีที่แล้ว
Use Word mail merge to send emails, with all the missing features added back in. Features like adding attachments, having a custom subject, using the CC and BCC fields, using "Send As" (e.g. send as the CEO, you know you want to), and best of all you can save to drafts to check the emails before they go out. We take you through how to add in a Word macro, set up your data, and create a set of e...
Mail Merge to Separate PDFs with Custom File Names and Folder Locations. No Plugin Needed!
มุมมอง 279K3 ปีที่แล้ว
UPDATE! Mac code now available on website! We tell you the best way of converting your Mail Merge into separate PDF documents so that each PDF has an individually defined file name and folder location. This is done using a Word Macro, so you avoid some horrible complex process, any need for a paid-for third-party plug-in, and if you've got that far, any need to re-name and sort out a folder ful...
Hi,Can you please share the macro for the newer version for office 365 as the 2021 version is not working ?I am constantly getting the error 5941-The requested member of the collection does not exist.Thanks
Does this work on a Mac computer?
A waste of 23 minutes!
I'm getting an error message with the macro: "Run-time error '5853' Invalid Parameter" This is highlighted: masterDoc.MailMerge.DataSource.ActiveRecord = wdFirstRecord
Hi! Thank you so much for these videos, I followed the mail merge to PDF video and it saved me so much work! Truly a life saver! Questions: Does the macro code in this video also work for Macs? If not would you be able to list a macro made for this email function that would work with Macs? Thank you!
This was such a great video, and it worked for a while, but then I got the Run-time '9105': String is longer than 255 characters. Does anyone else get this, and do you have any idea how to fix it?
Hey Simon, how can we make this but using the new Outlook app?
Hi, how to modify the Macros when we have the same file name? Like in your example: If I wanted to save file name based on the name of the person and that person has two records. "Adam Griffith". For the first iteration file gets saved and next it gets replaced by the second record. But in my case I want the data for two records seperately. Can you please let me know how to include that in the macros.
Struggling to get the mail merge to work with a header. Works if i remove header. Any ideas? I must create various documents with a header. Thanks in advance
Great video Simon, it helpd me a lot. Could you please give me ideias on how to include a unique clickable web link for each person in the excel file? Thanks.
God bless you
How to resolve 5852 error?
Great tutorial - I am having an issue where of my 10 lines on xls, only my first line is being sent. I am trying to send multiple emails to the same person on different days with diffrent files. Is there any reason this isnt working ? Any help is appreciated
Thank you so much . I am using office 365. It worked after the run time error 5152. In attempting to get the DocFile name I also noticed that text on my reference cell had the slash (/) sign in it and after running the macros it stop before the cell that had the Slash sign in it. I removed all the slash sign in the text of my referenced cell and it finally worked fully .🙏
I can't seem to get around the runtime error. My columns are named correctly. Anyone got any help?
OMG I just danced & jumped around the office. I just did 585 construction log records in 45 minutes!!! Just splitting the files and renaming woukd have taken me a week. Thanks, Thanks Thanks
This was exactly what I was looking for! I tried it out - and it works perfectly. Thank you so much
Wow, you, sir, are an absolute genius. This is such an amazing time saver. Thank you for the step by step explanation and for making the macro available. Definitely a channel I will subscribe to.
What would be very useful is to give an example of how to find the path on a Mac, as this is not obvious.
Thank you for this, it is so helpful!
It works very well, it only does not work with signatures with images in it. after 2 or 3 emails the MS Word app will crash and you need to restart the process
Muito obrigado pelo excelente trabalho e por sua disponibilidade em comprtilhar seu conhecimento. Thank you very much for the excellent work and for your willingness to share your knowledge. Gilson do Brasil / Gilson from Brazil
Hi! Does this run with Mac?
I have watched your video on this and was hoping it will save me a ton of work saving so many PDF's with different names. But ran into an error and not sure how to fix it. Microsoft Visual Basic Run-time error '5853': Invalid parameter. How do I resolve it? please help. Actually i solved it myself both errors 5852 and 5853. it is working and saving both doc and pdf as you shown in video. wow!
This helps a ton!!! Can we also automate follow ups with this somehow?
Thank you so much for this video!! I have a question. I get the message Errors were found when creating he email, email has been saved as a draft with subject: errors in mail merge" and a full list of errors in the body of the mail.... What can i do? Thank you
Thank you so much, the macros and this kind of videos saved my life!
This used to work beautifully but it no longer works :(
Can anyone help me, the attachment is not available in the mail, what could be the reason I followed the exact steps
Hello Sir, thank you so much for your work! this really save us a lot of time. May I check if we can set VBA auto label email before it was send?
Hi I'm facing this error -- Run-time error 5941 " The requested member of the collection does not exist
great stuff!
Can we use mail merge with meeting format ?
In case you are wondering, as of 06/26/2024, this wonderful macro still works with the latest version of MS Office
thank you very much sir
This is amazing. Thank you so much. I've been using your macros to create personalised PDF documents and mail merge with attachments, which helps me save tons of time.
Hi, thanks so much for sharing this video. I used your method once a couple of years ago, and I had no issues. I have tried again, and I am getting an error message. "Run-time error 5853. Invalid parameter." The issue highlighted is "masterDoc.MailMerge.DataSource.ActiveRecord = wdFirstRecord" Do you have a suggestion on how I may fix this issue?
I can't get this to work and am getting error 5941 despite following the video and website instructions exactly. Please can you advise on how to fix this? I've looked through the comments and can't see where anyone else has had this problem!
Is it possible to save the files in png format ?
You are incredible! Thanks for this!
Thank you!!!!
@imnoss Hello, and I love this macro and videos. I am getting the 5941 error this year, having used this same process for the last two years (in June). Update: In Word, when selecting the data source, do NOT check the box that says "First row of data contains column headers"
Works perfectly, thank you!
fantastic work has made our life so much easier, cannot recommend this enough
Thank you so much. You really made my day. :)
Is there a way to customize the macro so it doesn't create the PDFs, but instead just spits out individual word docs instead?
Great content!!! This channel is underrated.👏
Bravo!!!!! Thanks
I did a mini dance when I ran the script! you saved me an enter day on mail merging 102 documents
Great Tutorial! Easy to follow and works as expected. 👏