sibsanne
12-16-2011, 05:25 AM
Dears,
I'm new to excel.
A month ago had to start to work with it and a lot of action I need to perform are quit recurrent (my wrist hurts :().
So I try to automate them as much as possible.
I have been able to do a lot already.
I need a last macro that I action trough a button.
I use excel 2007 and outlook 2007.
I'll try to explain what I need:
Depending on the row I'm on by triggering a button I need a ready to send email with attachment to be generated.
The mail should be pre-filled with the data that can be found in the row.
Here is the template.
To: VALUE IN #Y
Cc: VALUE IN #Z
Subject: TEXT TEXT VALUE IN #A/VALUE IN #B VALUE IN #C VALUE IN #D
Attached: VALUE IN #W
'TEXT,'
'TEXT TEXT TEXT TEXT TEXT'
TEXT: VALUE IN #A
TEXT: VALUE IN #B
TEXT: VALUE IN #C
TEXT: VALUE IN #D
TEXT: VALUE IN #M
'TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT.'
'TEXT.'
'My outlook signature'
# would be the value of the row i'm on
TEXT stands for some free text I need to complete the mail template.
The attached file is an external excel file or pdf file.
I could also gather all the data needed for the subject in one cell under one column.
The value in the attach form is the URL to the file.
Do you think one macro triggered trough a button can do that and gather the info depending on the row your are on?: pray2:
Thank a lot for your time.
I know it's a elaborated request.
I've found a lot on the net, but nothing that goes close to what I need or that I'm able to adapt myself.
Best regards,
I'm new to excel.
A month ago had to start to work with it and a lot of action I need to perform are quit recurrent (my wrist hurts :().
So I try to automate them as much as possible.
I have been able to do a lot already.
I need a last macro that I action trough a button.
I use excel 2007 and outlook 2007.
I'll try to explain what I need:
Depending on the row I'm on by triggering a button I need a ready to send email with attachment to be generated.
The mail should be pre-filled with the data that can be found in the row.
Here is the template.
To: VALUE IN #Y
Cc: VALUE IN #Z
Subject: TEXT TEXT VALUE IN #A/VALUE IN #B VALUE IN #C VALUE IN #D
Attached: VALUE IN #W
'TEXT,'
'TEXT TEXT TEXT TEXT TEXT'
TEXT: VALUE IN #A
TEXT: VALUE IN #B
TEXT: VALUE IN #C
TEXT: VALUE IN #D
TEXT: VALUE IN #M
'TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT.'
'TEXT.'
'My outlook signature'
# would be the value of the row i'm on
TEXT stands for some free text I need to complete the mail template.
The attached file is an external excel file or pdf file.
I could also gather all the data needed for the subject in one cell under one column.
The value in the attach form is the URL to the file.
Do you think one macro triggered trough a button can do that and gather the info depending on the row your are on?: pray2:
Thank a lot for your time.
I know it's a elaborated request.
I've found a lot on the net, but nothing that goes close to what I need or that I'm able to adapt myself.
Best regards,