Hi,

I've been reading some Rob de Bruin scripts for sending email from
Excel. My problem is that the user would need to be able to select who
the recipient would be. I want to send a generic email reply, but to a
different person each time.

Is this possible?

Thanks in advance.

Tanya


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=549107

Hi Tanya,

You could replace a code line like:

.To = "

with

.To = Activesheet.Range("A1").Value

---
Regards,
Norman



"tanyhart" wrote in
message ...

Hi,

I've been reading some Rob de Bruin scripts for sending email from
Excel. My problem is that the user would need to be able to select who
the recipient would be. I want to send a generic email reply, but to a
different person each time.

Is this possible?

Thanks in advance.

Tanya


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile:
http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=549107

Norman Jones Wrote:
Hi Tanya,

You could replace a code line like:

.To = "

with

.To = Activesheet.Range("A1").Value

---
Regards,
Norman

View this thread
http://www.excelforum.com/showthread...hreadid=549107


Actually, the quickest and easiest way to deal with this would be t
change .send to .display in your options, and don't use ".To" . Wit
send the email address is entered in the form you're creating (i
there's a cell/field designated for it). with display, it just open
the email, and you set the email address in Outlook, rather than i
Excel

--
ljsmit

-----------------------------------------------------------------------
ljsmith's Profile: http://www.excelforum.com/member.php...fo&userid=3053
View this thread: http://www.excelforum.com/showthread.php?threadid=54910

Hi tanyhart

Click on the tip link on each example page

--
Regards Ron De Bruin
http://www.rondebruin.nl



"tanyhart" wrote in message
...

Hi,

I've been reading some Rob de Bruin scripts for sending email from
Excel. My problem is that the user would need to be able to select who
the recipient would be. I want to send a generic email reply, but to a
different person each time.

Is this possible?

Thanks in advance.

Tanya


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=549107

Thanks for the help. I got it to work the way I wanted it to. :

--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514
View this thread: http://www.excelforum.com/showthread.php?threadid=54910