Hi Mahesh,
Please find macro attached for mailing through Outlook.
Happy Emailing
Regards,
Shah
On Thu, Apr 16, 2009 at 9:55 PM, mahesh parab wrote:
> Dear All
>
> I have excel sheet. This excel sheet has data for many receipnts,
> I want a macro to be created so that when
Hi Ayush, thnks for sharing this information, II am using your idea to
update a table which contains employee and amounts column, here I need one
more help I have a chart and I need to colour few bars if the amount is
greater than 50 or 40 USD every day, and I want help where in if the table
is upd
Dave, You can also select cont+G, click on special tab and again click on
formula's tab, all cells whic contain formula's will get highlighted, you
can now select the fill color option and colour the cells with your
favourite colour.
Regards,
Shay
On Tue, Apr 14, 2009 at 10:24 AM, Dave Bonallack
Hi Rabindra,
Please find the excel where password is removed.
Regards,
Shay
On Mon, Jan 19, 2009 at 8:23 PM, Rabindra Thapa wrote:
>
>
> On Mon, Jan 19, 2009 at 7:23 AM, shay shay wrote:
>
>> please mail ur file.
>>
>> On Sat, Jan 17, 2
Hi All,
this question was asked byone of our memgers, wherein as soon an excel
opens it has a list of reminders and it shows as a message box to the recent
date.
Kindly forward me the solution as I am not able to find in my inbox.
Regards,
Shay
--~--~-~--~~~---~--
please help me with count function
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.
Hello Debasish,
I suggest you to follow below steps instead of macro.
1. Selct the column which contains both blanks and non blank cells.
2. Press Control+G and here u wil get various options, click Blanks and
say ok, u will see that all blank cells are highlighted.
3.
please mail ur file.
On Sat, Jan 17, 2009 at 8:08 PM, Rabindra Thapa wrote:
> i protected by password on my working files but after long time when i
> try to open it , i can't please advise me how to open my files.
>
> >
>
--
Shay
A Thinker tends to use reason and logic
A feeler tends to us
Hi All,
can any one help me with a filter macro which will filter the all
the invoices based on monthly basis like jan , feb etc and I also want to
cretae pivot as well as chart togethere and this pivot and chart shd update
automatically.
--
Shay
A Thinker tends to use reason and logic
Hello Ken,
After replacing microsoft with my company name then also i am facing an
error which is "the sendusing configuration value is invalid"
Regards,
Shay
On Tue, Jan 6, 2009 at 5:48 PM, shay shay wrote:
> Hello Ken,
>
> I am still facing the broblem. I
://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25
> .Update
> End With
>
> With iMsg
>
>Set .Configuration = iConf
>.To = strTo
> ' .CC = strCC
> ' .BCC = strBCC
>.from = strFrom
>
; .Send
> End With
> Next i
> MsgBox "All Mails Sent succfully"
>
> Application.ScreenUpdating = True
> Application.DisplayAlerts = True
>
> End Sub
>
>
>
> On Jan 5, 10:13 am, "shay shay" wrote:
> > Hello All,
> >
> >
Hello All,
I have an excel sheet and it contains 800 client names in
column A, I want to mail these 800 clients using outlook, is there any way
where in I can create a macro which automatically mails these people as soon
as I open the excel sheet. its similar to mail merge activity bu
13 matches
Mail list logo
