Opening e-mail addresses in a blank Outlook e-mail

**Barking_Mad** · 06-02-2010, 10:44 AM

I have a excel sheet that keeps track of work handed in to our office. Alongside each name we have the persons e-mail address. I’d like to be able to multiple select (Ctrl+left click) the emails then click a macro attached button which would paste all the selections into the BCC field of a blank Outlook 2007 e-mail. Ron De Bruin has some stuff which ive looked at but cant quite get it to work properly. Does anyone have any ideas? Any help would be super

**Kyle123** · 06-02-2010, 12:26 PM

Hi,

You could use the following, you'd need to set a reference to the outlook object library

Please Login or Register  to view this content.

EDIT: Oops - just noticed you use 2007 - I don't have that and haven't used it. Give the above a whirl though, might work

**Launchnet** · 06-02-2010, 08:09 PM

Hi . . .

Depending on how often and how many emails are to be sent, I have a quick manual suggestion.

Your email addresses are all in 1 column on your sheet.
Select all
Go to your email account
Click on BCC
Paste all addresses into BCC box by CTRL V

I use this all the time. Very easy. Also very nice if you use dual monitors as I do.

I also wrote an email tracking program in excel where you can have many different lists and by simply clicking on the appropriate column, it will select all the email addresses for the appropriae category and copy them into the clipboard automatically.

Then go to your second monitor with your email program and CTRL V into BBC

My email account has been hacked into several times, where emails have been sent out under my name and from my computer. This is why I wrote the program. Now, I no longer keep any contacts in my email account, plus it is much easier.

Good Luck

**Barking_Mad** · 06-03-2010, 04:50 AM

Hi thanks for both suggestions.

Launchnet - problem is you can't copy and paste selected multiple items from the list, just the entire column....any suggestions as to a work around?

**Kyle123** · 06-03-2010, 05:55 AM

Hi Barking_Mad

Did you have any luck with the code?

**Launchnet** · 06-03-2010, 11:59 AM

Well, Again, I have a manual way of doing it - I hope.

Please answer these 4 questions and maybe I can come up with other ideas. How many emails in your list, how often do you send emails from this list and how many emails are to be sent from your spreadsheet listing ? What determines if you want to send an email to these particular emails.

Current suggestion . . .
From your list do the following:

Hold the CTRL Key down and click on each cell that contains a email address that you want to send to.

NOTE: Do not use your roller button on your mouse to go further down your list than you can see on your screen. DO THIS: Keeping the CTRL Key down, use the scroll bar on the right of your screen as necessary. Remember . . . keep the CTRL Key down.

Continue clicking on all of the email addresses that you want to send to.

Now, while still holding the CTRL Key down, touch the C key (this copies your selection into the clipboard).

PROBLEM . . .

You can not simply go to your email and paste in the email addresses. When I tried this, I got extra email addresses that I did not select.

SOLUTION . . .

Release the CTRL Key.

Go to a blank column, let's say column M1, providing it's blank.
Now touch CTRL V (Pastes all the selected addresses into column M eliminating all the blank fields between selected emails.

Now, select all of the emails in column M and touch CTRL C to copy, then go to your email program.
Click on BBC . . . Then paste here using CTRL V.

By using BBC, you don't distribute all the email addresses to everyone you are mailing to.

You also need to have 1 email address in the TO: field. I always insert my email address and I then receive a copy for my records.

Better than nothing, but if you answer the 4 questions at the top of this post, maybe I can give you a way to select the emails automatically using a macro, but I don't really know yet, as alot depends on your answers.