Send Dynamic Email

[ashani]

Hi,

I wonder if someone could please guide me and put me in the right direction.

I'd like to to have the following email functions in my workbook :

- I have 4 different templates (body text for email) - based on what user select from Cell B10 - excel to pick up that specific template and create email in Outlook.
- Also, in the email - Excel to select buyers Title from Cell B6, Name, B7 and email address from B9.
- In template - autofill the contact date which is in Cell B11.

I have created a template in Word but can move to excel or notepad - whatever you suggest.

Please can someone help me with this.

Many thanks,

 

[ashani]

Here is how it looks like
all the template is on cell AA2 to AE2
everytime user select template 4 for example - ex

cel to create email with title, name, email and contact date

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Email Dynamic
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ashani]

apologise - it won't happen again

Email Dynamic

hi gurus, I wonder if someone could please help me with the attached file. I'm looking for a dynamic email by VBA - the email should create from the different template which I have also saved in excel in another worksheets but change the tile, last name and contact date according to what...

www.excelforum.com

 

[ashani]

Anyone can help in this pls ?

 

[TraderEsad]

Do you still need help with this? this shouldn't be too difficult to create. Simple process to send out the emails via excel with conditional rules based on the name.