954,551 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Add a name in the TO: address with code

In my form I have a field (Reqby) that will request the name of the Dept. Manager. Is there a way that I can take that information and add it to the TO: line?

The TO: line already has a name in and I want to add the Dept. Managers to it.

dreyes67
Newbie Poster
23 posts since Jan 2005
Reputation Points: 10
Solved Threads: 0
 

The TO line of a VB Form?

Comatose
Taboo Programmer
Team Colleague
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
 

The form is a MS Outlook form. I have attached the MS Outlook where I am requesting the name of the Dept Manager. Then I want to see if I can add it to the TO: line at the top.


Sub Update30()
Dim recip
Set recip = Item.Recipients0.Add (Item.userproperties.Find("Deptman").Value)
recip.type = olTo
End Sub


If I wanted to use Global Address List instead of Recipents what is the "code" for it

Attachments reqby.jpg 68.18KB
dreyes67
Newbie Poster
23 posts since Jan 2005
Reputation Points: 10
Solved Threads: 0
 

What is the NAME of that textbox?

Comatose
Taboo Programmer
Team Colleague
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
 

In the example I used the name DEPTMAN

dreyes67
Newbie Poster
23 posts since Jan 2005
Reputation Points: 10
Solved Threads: 0
 

Hmn.... I'm hoping I'm not off on a limb here, but check this URL:
http://www.microsoft.com/exceldev/articles/bulkmail.htm

Comatose
Taboo Programmer
Team Colleague
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
 

Looks like some heavy reading. I will look it over, but it still contains some interesting information.

Thank you

dreyes67
Newbie Poster
23 posts since Jan 2005
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You