Dear List members
Request : *Mail merge and E mail* using VBA or other tools
=
- I have to send reminder / dunning letters to my customers.
- Unfortunately the faxing option from the company is very time
consuming (print,
basic
>>address info as in sample
>>- Each e mail [body of email ] should have a common format , dear sir
>>/ madam .. please effect payment etc tc but the data (like total
>> overdue value and list of invoices would vary)
>>- Also, I hope to
Hello Stranger,
I can see your query and would like to get it done but before doing this I
am curious to know something related to your query.
Are you having invoices info and customer info in different workbooks?
If yes then In attached Sample list of Invoicing, I can see only few
inputs. Are the
the rest is up to you to choose and tell me to do / follow
--
Regards
Subu
mail_to_s...@yahoo.com
From: Anoop K Sharma
To: excel-macros@googlegroups.com
Sent: Monday, 24 December 2012, 10:00
Subject: Re: $$Excel-Macros$$ Mail merge and E mail
change the yellow line to
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")*
or add a reference to Microsoft Outlook 9.0 Object Library from Tools -
Reference
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use co
Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to
customers using VBA
change the yellow line to
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")*
or add a reference to Microsoft Outlook 9.0 Object Library from Tools -
Reference
--
Join official
> reference) to MS Outlook 11 object library in VBA Editor -> tools ->
> References
>
> Thanks in advance for your help
>
> --
>
> Regards
> Subu
>
>
> mail_t...@yahoo.com
> --
> *From:* bpascal123 >
> *To:* excel-...@go
GentlemenI really appreciate both of you trying to help
meLet me wait for Anoop's reply I am very confident that
the end result is something that will help me and also help many others trying
to send automated / format letters over e
mailRegardsSubu
--
Join official Facebook page of this foru
: * aks.sharm...@gmail.com ;
> bpascal...@gmail.com ; Subu S <
> mail_to_s...@yahoo.com>;
> * Subject: * Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email
> to customers using VBA
> * Sent: * Fri, Dec 28, 2012 1:30:00 AM
>
> Hi Subu
>
> I haven't tried the