Michael has attended:
Excel Advanced - Formulas & Functions course
How to turn text in excel to mail?
We made a summary customised email for a group of people in excel per cell and now we want to turn these texts in excel to an outlook email ready to send to all these people.
How do we do this easily? (rather than the manual way of copying text from each excel cell, opening a new outlook mail, and then pasting the text in)
RE: how to turn text in excel to mail?
Hi Michael,
Thank you for the forum question.
Excel need to be VBA coded to do what you want. We are doing this on our advanced Excel VBA course. I will need to have advanced VBA knowledge to automate emails from Excel.
MS Word mail merge can send email to a list from Excel, but not add text to the body.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: how to turn text in excel to mail?
Thank you for your answer! A shame that VBA is required. I might look into this further one day.
RE: how to turn text in excel to mail?
Hi Michael,
VBA is very powerful and can automate all repeating tasks, but it takes some work to learn it.
Sorry I couldn't help you with "normal" Excel.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
