Re: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Vincent Torralbes
Forgot to attach email On Tue, Aug 2, 2011 at 8:55 AM, Vincent Torralbes wrote: > Thank you Rajan, this certainly helps, but it doesn't maintain the > formatting. Attached is the format I'm trying to maintain on the email > body. Also, when I click on the button (execu

Re: $$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Vincent Torralbes
; > *outLookApp.Quit* > > *Set outLookApp = Nothing* > > *MsgBox "Mail Has been Sent ", vbInformation* > > *End Sub* > > * * > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf O

$$Excel-Macros$$ Emailing from Spreadsheet

2011-08-02 Thread Vincent Torralbes
I have a sheet where I have data populated based on a drop down list. I want to be able to copy the data (A1:F40) and email it to an email address on cell C5. Currently I have to manually copy, open up outlook, paste the data then copy and paste the email address. Is there a way at the push of a

$$Excel-Macros$$ Calculating distinct events by ID

2011-07-16 Thread Vincent Torralbes
I have a table where I maintain a log of every contact event I make with my customers. In a Pivot table, I'm trying to return and calculate the first contact event made by unique ID. When I pivot by ID and dump in "Log Contact", it sums up all the contacts. If I use the Max function, then it doe