PDA

View Full Version : CODE FOR JOB



pavlito
01-20-2012, 04:48 PM
Hello peoples.

I need help from someone who can help me.

I do not know to write code, so I think that I contact for help in this forum. I see that there are many experts who work with vb.

I work in a company (bank), and do all sorts of stupid paperwork. I do know how to write code, i gratuated economy.

Every day I get Excel spreadsheet with some client transaction data, okand I need to forward to the various branches.
In general, I copy a row with several columns, and paste in outlook mail. I do that 300 times per day. It is little annoying.

So my question If someone knew and had time to write that code that would specifically perform the job (automatically) the way I work manual?

I can write little more details about that?

jolivanes
01-21-2012, 02:10 PM
Could this be a start for you?

http://www.vbaexpress.com/forum/showthread.php?t=19917 (http://www.vbaexpress.com/forum/showthread.php?t=19917)

mdmackillop
01-21-2012, 03:20 PM
Welcome to VBAX
If you can post a sample workbook showing your layout etc. and how your email addresses are stored this would assist. If you use Outlook, you may need an add-in like Redemption (check the KB for some examples) to allow Excel to send without user intervention.
You can post a workbook using Manage Attachments in the Go Advanced reply section

pavlito
01-24-2012, 02:39 PM
Welcome to VBAX
If you can post a sample workbook showing your layout etc. and how your email addresses are stored this would assist. If you use Outlook, you may need an add-in like Redemption (check the KB for some examples) to allow Excel to send without user intervention.
You can post a workbook using Manage Attachments in the Go Advanced reply section

Thanks for the help, i appreciate it...

In attachment are samples of excel table and emails that represents how i work manualy with that.

pavlito
01-24-2012, 02:48 PM
addon

Kenneth Hobs
01-24-2012, 02:51 PM
That does not help me see what you need. Where are the email addresses? What data is needed for each email or group email?

Take some to time to write short and specific examples.

I find that PDF files are a good way to show data. One option is to create PDf files either in Excel or merge to MSWord and create from there and then attach them to the email.

pavlito
01-24-2012, 02:57 PM
Additional detail:

U will se how i copy from excel and paste to the mail for every cardholder.

The value in the column "entity" represents branch name.

So if the entity is for example value "52' i need to adress name
TO: branch base (example)

There are aproxx100 branches/entities.

It would mean a lot for me if u could help me to solve this problem?

pavlito
01-26-2012, 10:30 AM
That does not help me see what you need. Where are the email addresses? What data is needed for each email or group email?

Take some to time to write short and specific examples.

I find that PDF files are a good way to show data. One option is to create PDf files either in Excel or merge to MSWord and create from there and then attach them to the email.

Ok.

I make pdf example. it is in attachment.

pavlito
01-26-2012, 10:31 AM
this is colored pic, for better visualistion of data.

Kenneth Hobs
01-26-2012, 12:30 PM
Is your real XLS data as it is in your example where the 2nd row is blank with 2 blank rows separating each email set?

Is Entity value of 100 in some lookup named range? For now, I would just assume that 100 is the value for Outlook's To field.

Some people say Outlook but they really mean Outlook Express or even Windows Mail. Since you say that you know how to code then see some outlook routines at: http://www.rondebruin.nl/tips.htm

You might want to use CDO to bypass some security issues on automated sending. http://www.rondebruin.nl/cdo.htm also see http://www.vbaexpress.com/forum/showthread.php?t=22439


I would probably use a variation of some CDO routine in the referenced links. If locked out of CDO, install: http://www.dimastr.com/redemption/

pavlito
01-27-2012, 10:48 AM
Is your real XLS data as it is in your example where the 2nd row is blank with 2 blank rows separating each email set?

Is Entity value of 100 in some lookup named range? For now, I would just assume that 100 is the value for Outlook's To field.

Some people say Outlook but they really mean Outlook Express or even Windows Mail. Since you say that you know how to code then see some outlook routines at: http://www.rondebruin.nl/tips.htm

You might want to use CDO to bypass some security issues on automated sending. http://www.rondebruin.nl/cdo.htm also see http://www.vbaexpress.com/forum/showthread.php?t=22439

I would probably use a variation of some CDO routine in the referenced links. If locked out of CDO, install: http://www.dimastr.com/redemption/

Kenneth,

I made another example with explanations and details for your questions.
i put another 2 screen shots mail looks. Im using outlook2003 and excel2003