943,985 Members | Top Members by Rank

Ad:
Apr 6th, 2005
0

Add a name in the TO: address with code

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dreyes67 is offline Offline
23 posts
since Jan 2005
Apr 6th, 2005
0

Re: Add a name in the TO: address with code

The TO line of a VB Form?
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004
Apr 6th, 2005
0

Re: Add a name in the TO: address with code

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
Attached Thumbnails
Click image for larger version

Name:	reqby.jpg
Views:	13
Size:	68.2 KB
ID:	1044  
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dreyes67 is offline Offline
23 posts
since Jan 2005
Apr 7th, 2005
0

Re: Add a name in the TO: address with code

What is the NAME of that textbox?
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004
Apr 7th, 2005
0

Re: Add a name in the TO: address with code

In the example I used the name DEPTMAN
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dreyes67 is offline Offline
23 posts
since Jan 2005
Apr 7th, 2005
0

Re: Add a name in the TO: address with code

Hmn.... I'm hoping I'm not off on a limb here, but check this URL:
http://www.microsoft.com/exceldev/articles/bulkmail.htm
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004
Apr 7th, 2005
0

Re: Add a name in the TO: address with code

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

Thank you
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dreyes67 is offline Offline
23 posts
since Jan 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: checkboxes on continuous forms
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Access and VB





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC