convert text to VBA

The text below starting from "Dear Member" will be sent in the body of an email via a macro in excel. Is there away of adding the VBA coding etc. to this text quickly so that the text is sent in exactly the same format as below i.e. same font, spacing, size etc.


Dear Member

The THS Marketing Toolbox will be ‘going live’ at the THS AGM on Thursday 11th June 2015.

One of the new great features on the THS Marketing Toolbox is an E-shot building system which not only will Members have access to but Suppliers will also be able to use it to send you ‘the Member’ details of their latest deals to be featured on the Toolbox.  As such we would like to take this opportunity to up-date our email address database and attached are details of the addresses we currently hold on file for your company and as such will receive all e-shots generated by a Supplier using the Toolbox.  Could we please ask you to take a look at the attached spreadsheet, add, remove or amend where applicable and return by email by no later than close of business Monday 8th June.

If we do not hear from you, we will assume that details held are current and correct.

Many thanks and regards


Sally Barry
Project Manager
(Normal Hours of Work: Wednesday & Thursday 9.15am – 5.15pm and Friday 9.15am – 4.45pm)

THS Tools Group
Salisbury House
Centurion Business Park
Templeborough
ROTHERHAM S60 1FB

Tel: 01709 724000
Fax: 01709 724018
Email: sally.barry@thstools.co.uk
mikes6058Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
It might be simpler to create a template email with all that text in, then your code can just create a new email based on the template, attach your file and send it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
Sally needs to look at her grammar, that paragraph in the middle is atrocious!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.