 Hi, well says hi all not sure if this is the right group but does anyone know of a free added or similar or a way of using their native features within 365 to have custom subject lines in mail merge emails Standard seems to be one subject for all emails sent using mail merge I have found a number of paid for solutions, but they all contain many more features that I need I just want custom subjects no need for attachment CC BCC. Thanks Okay, so Mail merge you can actually go in and as part of your mail merge and you get your You know inward you'll go in you'll get yourself started and when you get yourself started and You go start doing select your recipients. You type a new list. So you go into there and then you get that new You get your dialogue box pop up and in there. You've actually got a customized columns Feature so in that customized columns feature you can go in there You'll get another window it pops up and you can click on add and when you click on add It gives you a blank field that you can work with and you can put in whatever it is you like So if you go, I want to bring in subject you put subject in so that when you've got your columns in Excel You can actually go in there and then put whatever subject it is You need for a column and then once you get into your document put that particular Field in their subject and it will just draw from the Excel document. Whatever it is that you want as a custom subject So then you have to look at is it because something that's conditional in Excel So if it's got this amount of dollars then pull from this in the list to drag in that as a You know as a column header Then you that's stuff that you need to do over in Excel to draw the right information So that you can have is it a word document and then that goes over I think the difficulty is if you're talking about it coming over into Outlook and Bring it into Outlook as a subject header. That's where things start to go a little bit a little bit more different Yeah, I've had the only I think suggestion that I was possibly using a list a Microsoft list or SharePoint list and then using power automate to generate the emails might be another option too because then you can map that dynamic content from the list which Excel could be a data source, I believe and then Into the actual email as it generates it so that could be another option as well But I everything everything Christie said because I was like, yes Yeah The size of the list that you're trying to you know, usually when you're doing mail merge I mean something that you don't want to do manually obviously and it to push those out So, you know, what are you talking about? I mean, I would say are you talking about? Variety where every one of them is different Do you have something that's specific for an individual are the majority of them consistent the same and yet only again? I think this is Kirsty with what you said. It's totally valid if there's certain criteria where there's a different one where you have it in there I mean, I was thinking that you could even on those It may be much more efficient if if you went and collected built a table in Excel and Then got creative and wrote something unique to those those that person To those people and then the rest are the same and then do the mail merge pull in the fields, you know populate that that field Versus like like I don't know how if all of them are unique Then you want everything automated except you want to type that in I mean I guess technically you could go and build a power app that would have a pop-up as you go to publish it and Pops up and you just sit there typing this the unique subject for each one of them and hit enter to finish it off I mean, there's a lot of things you could do depending on what you're trying to achieve but At that point to go and build that to find somebody that can build that and then go and do that I mean, I might if you're talking about a couple hundred it might be faster just to do it manually Yeah, so it's out Robins has got an adding It is a free add-in in terms of the merging tools add-in You just have to work your way through I've put a link into our chat on how to do that because you'll have to create that That customized subject and then have a look and then start to bring it in and he's got it He's actually got an add-in. It's it's free But it also depends on what version of office You're actually using and the version of of outlook because the outlook knew the monarch does not have Melmerging it as such yet So you'd need to make sure that you were using classic to be able to work with the add-in and Doug's pretty good at keeping up to date on a lot of his Add-ins his free add-ins and things like that. He's you know being Doug's been doing this for you know, really really really long time Yeah, I'm really shocked. I you're saying that Microsoft is releasing a new product that doesn't have all of the features that people rely on in the older Did you just put your tongue in cheek Christian? That is shocking. I know I'm shocked No, so many features not in there yet look at they say it's going to get there But Malmo just gonna have to be one that you know, they'll have to work on pretty fast because it's Businesses rely on that capability. Yeah, I know that if folks we're not gonna get in this, too I mean Microsoft is feeling I'm sure pretty hammered Not the hammered, you know that maybe a little bit, but they're getting hammered by the MVP community over the How many features are missing from the new outlook? So but that's it's a key feature that a lot of small businesses run on that. Yes, right Yep, even big businesses. There's so many if just even for internal emails and little own external So it's a it's a feature that's you know, well missed at the moment So especially if they wanting to use co-pilot, so make sure you're using the right Application to be able to use the right this right that at the moment Yeah, there's a bit of confusion around there as to what you can and can't do across which application right now Copilot otherwise known as clippy plus It's clippy's children Clippy pro. Yeah, that's it. It's the yeah, it's it's the grandkids of clippy. Oh, man. Hang on. I'm feeling old now