Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
Hey, I'm kinda new to vba and was wonderying if anyone could help with
my code. I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. I found some code to send email but it was a little different than what I want to do. If anyone can help point me in the right direction please let me know thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
What email client are you using? Maybe something like:
Dim sJect As String sJect = yoursheet.Range("a1").text Cliff Edwards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
If you haven't already, check out Ron de Bruin's site.
http://www.rondebruin.nl/sendmail.htm HTH, Paul -- "Magicman" wrote in message ... Hey, I'm kinda new to vba and was wonderying if anyone could help with my code. I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. I found some code to send email but it was a little different than what I want to do. If anyone can help point me in the right direction please let me know thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
On Mar 28, 11:24*am, "PCLIVE" wrote:
If you haven't already, check out Ron de Bruin's site. http://www.rondebruin.nl/sendmail.htm HTH, Paul -- "Magicman" wrote in message ... Hey, I'm kinda new to vba and was wonderying if anyone could help with my code. *I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. *I found some code to send email but it was a little different than what I want to do. *If anyone can help point me in the right direction please let me know thanks!- Hide quoted text - - Show quoted text - I am using microsoft outlook, I will check out the site thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
On Mar 28, 11:36*am, Magicman
wrote: On Mar 28, 11:24*am, "PCLIVE" wrote: If you haven't already, check out Ron de Bruin's site. http://www.rondebruin.nl/sendmail.htm HTH, Paul -- "Magicman" wrote in message ... Hey, I'm kinda new to vba and was wonderying if anyone could help with my code. *I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. *I found some code to send email but it was a little different than what I want to do. *If anyone can help point me in the right direction please let me know thanks!- Hide quoted text - - Show quoted text - I am using microsoft outlook, I will check out the site thanks.- Hide quoted text - - Show quoted text - I got it to send the attachment but am having problems with sending to more than one person and getting the subject to display a cell in the sheet? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
Click on the Tip link on each page
For Outlook this one http://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Magicman" wrote in message ... On Mar 28, 11:36 am, Magicman wrote: On Mar 28, 11:24 am, "PCLIVE" wrote: If you haven't already, check out Ron de Bruin's site. http://www.rondebruin.nl/sendmail.htm HTH, Paul -- "Magicman" wrote in message ... Hey, I'm kinda new to vba and was wonderying if anyone could help with my code. I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. I found some code to send email but it was a little different than what I want to do. If anyone can help point me in the right direction please let me know thanks!- Hide quoted text - - Show quoted text - I am using microsoft outlook, I will check out the site thanks.- Hide quoted text - - Show quoted text - I got it to send the attachment but am having problems with sending to more than one person and getting the subject to display a cell in the sheet? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to send email attachment
On Mar 28, 12:26*pm, "Ron de Bruin" wrote:
Click on the Tip link on each page For Outlook this onehttp://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "Magicman" wrote in message ... On Mar 28, 11:36 am, Magicman wrote: On Mar 28, 11:24 am, "PCLIVE" wrote: If you haven't already, check out Ron de Bruin's site. http://www.rondebruin.nl/sendmail.htm HTH, Paul -- "Magicman" wrote in message .... Hey, I'm kinda new to vba and was wonderying if anyone could help with my code. I want this template I created automatically sent through email and have it titled (subject) as a cell in the worksheet. I found some code to send email but it was a little different than what I want to do. If anyone can help point me in the right direction please let me know thanks!- Hide quoted text - - Show quoted text - I am using microsoft outlook, I will check out the site thanks.- Hide quoted text - - Show quoted text - I got it to send the attachment but am having problems with sending to more than one person and getting the subject to display a cell in the sheet?- Hide quoted text - - Show quoted text - Thanks a ton, works great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant Send Email Attachment | Excel Discussion (Misc queries) | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
Send Email with attachment from VBA? | Excel Programming | |||
I can't send attachment from excel by email | Excel Discussion (Misc queries) | |||
cant send email attachment from excel | New Users to Excel |