Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Auto Email via xlDialogSendMail addressing question

Hi DonC,

Try using the Array function:

Application.Dialogs(xlDialogSendMail).Show
")

Regards,

Jake Marx
MS MVP - Excel


"DonC" wrote in message
...
Hi All,
I'm using xlDialogSendMail in Excel to create a e-mail
with the workbook attached. If I enter 1 e-mail address
in ARG1, it works fine. If I enter multiple addresses,
seperated by a ; and space, Outlook does not recognize the
individual names-it sees the entire string a one name.
Anybody know if this can be done, and how??

BTW Both Excel and Outlook ver 2000 SR1

Thanks in advance,

DonC



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array addressing question... I think John Bennett[_2_] Excel Worksheet Functions 1 February 15th 10 11:04 AM
How do I create an email macro to auto fill the email? Justin[_4_] Excel Discussion (Misc queries) 0 November 14th 07 10:49 PM
Programmatically addressing worksheets - painfully stupid question Chip Pearson Excel Programming 1 September 8th 03 03:02 PM
Conflict between xlDialogSendMail and xlDialogPrintPreview Peter Ostermann Excel Programming 5 August 30th 03 10:19 AM
xlDialogSendMail O'Neil Excel Programming 0 July 10th 03 03:50 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"