Hello all,
first I want to mention, that I spent 30+ minutes searching/reading through articles. But so far I can‘t find a solution for what I am looking for.
It‘s not like this one here:
I try to keep it as less complex as possible ?
I explain shortly what I am aiming for. Every week I have to send a couple of reminders with almost the exact same content for unnecessary reasons… Only something like an order number and date will change. As the responsible people are lazy af and I am looking for this solution myself now. And I am not well experienced in scripting. Especially not for Excel.
So I want to not simply use „Mail Merge“. But in a macro script, write a specific text in the script that adds some information from specific cells, in specific places of that pre-written text. Short example. :
„Dear (name),
please provide the documents for following order (number).
Kind regards,
My name“
In reality the mail is a bit longer. But with this type of example I can make it.
So a click on the macro box would open a window to select the line number with the given information in.
Because the data to be added, like (name), will always sit at the same column letter.
Then, after selecting the right line number, automatically open Outlook, create a new mail with the script-written text, automatically add the (name) and (number) and use an e-mail written in an additional cell.
Yes I know, i will need to add it as in mail merge.
I think I am asking for a lot ? if i see the script I might understand how to edit the parts I need. But searching the internet alone since idk how long won‘t bring me anywhere….
Appreciate any advice.
first I want to mention, that I spent 30+ minutes searching/reading through articles. But so far I can‘t find a solution for what I am looking for.
It‘s not like this one here:
Mail merge using an Excel spreadsheet - Microsoft Support
How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.
support.microsoft.com
I try to keep it as less complex as possible ?
I explain shortly what I am aiming for. Every week I have to send a couple of reminders with almost the exact same content for unnecessary reasons… Only something like an order number and date will change. As the responsible people are lazy af and I am looking for this solution myself now. And I am not well experienced in scripting. Especially not for Excel.
So I want to not simply use „Mail Merge“. But in a macro script, write a specific text in the script that adds some information from specific cells, in specific places of that pre-written text. Short example. :
„Dear (name),
please provide the documents for following order (number).
Kind regards,
My name“
In reality the mail is a bit longer. But with this type of example I can make it.
So a click on the macro box would open a window to select the line number with the given information in.
Because the data to be added, like (name), will always sit at the same column letter.
Then, after selecting the right line number, automatically open Outlook, create a new mail with the script-written text, automatically add the (name) and (number) and use an e-mail written in an additional cell.
Yes I know, i will need to add it as in mail merge.
I think I am asking for a lot ? if i see the script I might understand how to edit the parts I need. But searching the internet alone since idk how long won‘t bring me anywhere….
Appreciate any advice.