Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send default email using Application.Dialogs(xlDialogSendMail).Show

Status
Not open for further replies.
barnard89

barnard89

MIS
Joined
Mar 6, 2005
Messages
74
Location
US
Hi
I am using Excel 2000.
I need to send excel file as an attachment to certain users using Microsoft Outlook
I am using Application.Dialogs(xlDialogSendMail).Show method to
send the excel file

There is an email id " R_brown@ibm.com" which has to be sent as a default email id .
This is irrespective of the number of email ids being sent

How can I make one of the email id as " R_brown@ibm.com" using Application.Dialogs(xlDialogSendMail).Show

Please suggest
Thanks
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question Question
Using Err.Raise question
Replies
2
Views
2K
mintjulep
M
aldi07
  • Locked
  • Question Question
update a front-end databases with a new release using vba
Replies
2
Views
548
aldi07
aldi07
Katto
  • Locked
  • Question Question
Translate word document using VBA
Replies
5
Views
975
macropod
macropod
remeng
  • Locked
  • Question Question
Show / Hide Shape VBA Excel
Replies
11
Views
2K
remeng
remeng
Zappd
  • Locked
  • Question Question
Unscramble word using data from spreadsheet.
2
Replies
38
Views
2K
Zappd
Zappd

Part and Inventory Search

Sponsor

Back
Top