Excel data to Outlook

[Robert Pollock]

Hi,

I have set up a database of people/faxes/email addresses
etc in Excel. I would like a user to be able to select a
range of addresses on the screen which will then be
arranged in one long text string separated with
commas/semicolons (I have worked out how to do that bit).

My problem is, can I use code for attaching a macro to a
button called, say "Paste" and the selection will be
copied and pasted into the "To" field in Outlook. I would
then have the macro close Excel, and leave the user
looking at Outlook on the screen with all the addresses
that they have selected nicely pasted in the "To" field
for them. If this is possible I would also like to be able
to select a file attachment from a list, and and some
standard text from a list.

Thanks
Robert Pollock

 

[Frank Kabel]

Hi
first: I wouldn' use Excel as an additional frontend for Outlook
Seems you're trying to re-programm Outlook functionality within Excel..

But for the first question have a look at Ron's excellent site:
http://www.rondebruin.nl/sendmail.htm

 

[twollens]

Robert, what you did to get a comma seperated list is actually one of
the things I am trying to do, can you let me know how you do this?

I am also trying to programattically select the same items in a list.
Basically I need to take a list of:

US joe
US lisa
US mark
Europe sam
Europe jack

and turn it into this:
joe, lisa, mark
sam, jack.

 

[Dick Kusleika]

Robert

You may find useful information here

http://www.dicks-clicks.com/excel/olSending.htm

Particularly, using the Recipients collection. You can add email addresses
to the Recipients collection, change whatever other properties of the
MailItem that you want, then use the Display method and close the workbook.
You should be left with an email message displayed and ready to send.