Mike’s videos are incredibly useful and he presents in a lovely, non-nonsense style so that even complete Excel numpties like me can use what he teaches successfully. Thanks @Mike Thomas
Awesome. Thanks Mike. The only thing I would have done differently is searching for the first backslash from the end of the text. That way it's more robust if the folderpath changes. Well done on another great video. Take care!!
@juliepeppitt9253 You can do the mailmerge. You can do the import from CSV. You can do the Merge Queries. What can't be done at the moment is loading the names of the files.
Is this a one time use mail merging method? I'm trying to save a word doc template that contains the mail merge linkage for future use too. I tried other methods but I wasn't able to save it for future use. My goal is to update the source excel file periodically and reprint the mail merge doc with new data and updates
Legend! Thanks
Morning Mike-only just squeaked in before midday - this is so interesting and very clever -really liked the demo
Mike’s videos are incredibly useful and he presents in a lovely, non-nonsense style so that even complete Excel numpties like me can use what he teaches successfully.
Thanks @Mike Thomas
Wow, thank you!
Awesome. Thanks Mike. The only thing I would have done differently is searching for the first backslash from the end of the text. That way it's more robust if the folderpath changes. Well done on another great video. Take care!!
Good call!
Can these same processes be done on the Mac?
@juliepeppitt9253 You can do the mailmerge. You can do the import from CSV. You can do the Merge Queries. What can't be done at the moment is loading the names of the files.
Is this a one time use mail merging method? I'm trying to save a word doc template that contains the mail merge linkage for future use too. I tried other methods but I wasn't able to save it for future use. My goal is to update the source excel file periodically and reprint the mail merge doc with new data and updates
This method should work repeatedly when you have different data in the source
Great Video.. How about if we wanted to send an email with an excel file through Outlook? Can that be another lesson? Thanks.
Yes, absolutely. I'll add it to my list!