Sending Email with Email body in a cell keeping the formatting.

**VBA_N_O_O_B** · 09-02-2017, 10:18 PM

Hi all,

I am new to the forum and VBA. All help is greatly appreciated. I am currently being tasked by my boss to do up a macro to send an email with the email body in a cell.

I have done my research and has found 2 macros that suit my needs however, i am having problems combining them. I am not sure what has gone wrong as i tried different combinations so that they can work.

I have attached a workbook here so every 1 has a easier time of viewing my code and my needs. Here are the links of the macros which i have used. https://www.rondebruin.nl/win/s1/outlook/bmail4.htm and https://social.msdn.microsoft.com/Fo...t?forum=isvvba

I want to paste the codes, but i cant. A firewall has pop up and stopped me from adding the codes. All help is greatly appreciated.

**Logit** · 09-02-2017, 11:17 PM

.
Paste into a Routine Module:

Please Login or Register  to view this content.

Hope you don't mind a difference in the macro code. This I had already in my toolbox.

**VBA_N_O_O_B** · 09-02-2017, 11:33 PM

Hi Logit,

I would like to thank you firstly for your swift reply. I really do appreciate it.

I have seen your macro but i need the auto bullet or numbering to be on. Your current macro is good, but my boss insists on having the auto bullet and number on as users are going to key in many more information in the form of bullets in that email. Do you have any other solutions ?

**VBA_N_O_O_B** · 09-02-2017, 11:35 PM

Hi all,

If you have any suggested solutions or workaround. Please feel free to reply in this thread. I thank all participants in advance for all the help rendered.

Sending Email with Email body in a cell keeping the formatting.

LinkBack

Thread Tools

Rate This Thread

Display

Sending Email with Email body in a cell keeping the formatting.

Re: Sending Email with Email body in a cell keeping the formatting.

Re: Sending Email with Email body in a cell keeping the formatting.

Re: Sending Email with Email body in a cell keeping the formatting.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] sending email with specific details in body of email

Search & Replace in email body when sending an email with Excel

[SOLVED] Creating email using Word document as email body – formatting lost

Sending the body of an email to excel

[SOLVED] sending email with specific range as email body vba modification

[SOLVED] sending email with a Picture in the body

Sending filtered range to email as body

Bookmarks

Bookmarks

Posting Permissions