Customise Email drafted by Excel

[woodland81]

My Sheet has a Button added. Where depending on what Row is selected. It will extract certain fields from that Row and insert into an Outlook Email.

Ive been playing around trying to alter the presentation however need some help.
So far been moving around & vbCrLf and & Chr(10)

The code is for the email to have already determined Text and then every now and again insert a piece of information from this sheet

Also Id like to know an easy way in VB editor to make it so that the line of Code doesnt have to keep going on and on, I put it on another row but then it made errors. only way it work play nice was for one long line

When I was at work Adding general text then reference to a field I was struggling, i moved question marks around

Please Login or Register  to view this content.

Look forward to learning more

Lee

[Leith Ross]

Hello woodland81,

This version of the macro should work. You have declared the wksht as a worksheet, but in the macro you type in wksheet instead.

The line can be broken in the VB Editor by using a space followed by a underscore. You can see this in the macro.

The CC and BCC strings will need to have a semi-colon inserted between addresses. This has been done on the CC string. There doesn't appear to be any cells assigned to the BCC string at this time.

Please Login or Register  to view this content.

[woodland81]

Hi,

oh thats great should save me never ending scrolling in the editor

Hmm i hadnt noticed the misnamed sheet. how come the emailer button still works?

I probably wont be using the CC or BCC strings

From the String Body, you can see im trying to write some text and then call for sheet info. does space underscore create a new line on the email as well as just in the editor?

Please Login or Register  to view this content.

[Leith Ross]

Hello woodland81,

The line continuation characters (space and underscore) are used only by the VB editor. They will not effect the formatting of the string.