Multiple email recipients from excel

**Brontosaurus** · 01-23-2010, 12:12 PM

Hi,

I have obtained the following code which works great apart from the fact that I want to just send one email to all addressees instead of multiple emails. Is there someone who could help modify it please;

Please Login or Register  to view this content.

I appreciate any help offered

Kind regards

Steve

**Richard Buttrey** · 01-23-2010, 12:50 PM

Hi Steve,

Welcome to the forum.

Please note the forum rules about putting VBA code inside

Please Login or Register  to view this content.

tags. As this is your first visit I have changed them for you this time.

Regards

**Richard Buttrey** · 01-23-2010, 12:52 PM

Steve,

Try the following modified procedure.

Please Login or Register  to view this content.

HTH

**mrice** · 01-23-2010, 01:08 PM

Try

Please Login or Register  to view this content.

**Brontosaurus** · 01-23-2010, 01:25 PM

Hi Richard,

Thank you for your help and advice. That worked perfectly and apols for absence of code tags - now understand this.

Kind regards

Steve

**Brontosaurus** · 01-23-2010, 02:04 PM

Hi Martin,

Thanks to you also for a quick response. I really appreciate your willingness to look at this for me.

Best wishes,

Steve

**Brontosaurus** · 01-23-2010, 03:09 PM

Hi,

Please would someone let me know how to invoke the macro by the easiest method

I'm thinking this is to have a cell in the worksheet which gets clicked

Again, help is appreciated

Steve

**Richard Buttrey** · 01-23-2010, 04:38 PM

Hi Steve,

Probably the easiest way is to add an object of some sort, an icon, picture, drawing object like a rectangle etc. and associate your TestFile macro with it. i.e. once you have the object on the sheet, right click it, choose 'Assign macro' and then select the TestFile macro.

Now whenever you click the object the macro will run.

You can of course also run it directly from the Menu, 'Developer > Macros if you're using 2007, or Tools > Macro > Macros with 2003.

HTH

**Brontosaurus** · 01-23-2010, 05:40 PM

Hi Richard,

This is very simple but very effective, thanks - as you can tell my Excel skills are not the best

Please would you help further with the vba code from the start of this thread?

1. How do I format the body content so that it is presented as two distinct columns

2. How do I add to the body content, the content of an additional cell or cells?

Hope I'm not asking too much

Best wishes,

Steve

**Richard Buttrey** · 01-23-2010, 07:20 PM

Hi,

What exactly is the Body content? Presumably the macro which contains "Dear Everybody" and "This is the message" is just an example. I'm assuming the real body is a paragraph of text in the workbook.

If so can you upload the actual workbook you're using?

Rgds