Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Send to Value xlDialogSendMail
I have recorded a marco for a command button on my form
that will do a file send to mail recipient (as attachment) when clicked but I want to also assign the address that the form will be emailed to as a default but when I try recorded this in the macro it doesn't except it. How do I assign the send to value? Help. Thanks Tammy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Send to Value xlDialogSendMail
I have some Example code on my site Tammy if
you use Outlook or Outlook express http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tammy" wrote in message ... I have recorded a marco for a command button on my form that will do a file send to mail recipient (as attachment) when clicked but I want to also assign the address that the form will be emailed to as a default but when I try recorded this in the macro it doesn't except it. How do I assign the send to value? Help. Thanks Tammy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Send to Value xlDialogSendMail
Tammy,
Got this from the ng Sub SendMyMail() Dim subj As String subj = InputBox("Enter your Subject Line", "email Subject") ' allows for a subject line 'Emails the activeworkbook' ActiveWorkbook.SendMail Recipients:="", _ Subject:=subj, ReturnReceipt:=True End Sub just put your default between the "" on the line ActiveWorkbook.SendMail , _ note that this works with outlook. Use this link to get more info http://www.rondebruin.nl/sendmail.htm steve "Tammy" wrote in message ... I have recorded a marco for a command button on my form that will do a file send to mail recipient (as attachment) when clicked but I want to also assign the address that the form will be emailed to as a default but when I try recorded this in the macro it doesn't except it. How do I assign the send to value? Help. Thanks Tammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
xlDialogSendMail | Excel Programming |