I've been using various resources on this forum to piecemeal together a macro that will help me perform the following task,
but it is becoming complex and beyond my reach of comprehension. My VBA knowledge is extremely limited, I can copy and paste
and kind of understand things, but being creative and writing things from scratch is beyond my reach.
I need to
create a macro that will pull in information from two different sheets in a workbook and paste it into an Outlook mail based
on certain conditions and allowing the mail to be in a format that is aligned and readable with a blackberry. I have renamed
everything because of confidentiality reasons. I hope it doesn't make it too difficult to understand.
my attached file.
1. I need to subject line to change based on the date in the file (cell A2 in
Daily Report tab and the Total Daily Produce (cell C10 in Email object tab.)
Produce Daily Report 8/28/07 + 7.1lb
The "+" sign in front of "7.1lb" should change to a
"-" sign in case it is negative (ha and I know weight can't be negative, bear with my example)
Putting together the Email - It needs to pull from two different tabs, Daily Report and Email Object tabs (email object tab
is all formulas, so it needs to be pasted as a value). I tried to copy an email macro that would select the sheet and copy it
into an email, but I don't know how to pull from the Daily Report tab only cells for produce whose Weight is greater than or
equal to 1.0 LB or less than or equal to (1.0) LB. It would need to pull in the "name - description" followed by
weight as shown in my example. (This section is where I am having the most problems, it is highlighted in yellow on my
desired email tab.) The rows in the Daily Report tab change constantly, I would need to be able to insert new rows and add
types of fruits under the bolded headings (Apples, Bananas, Peaches, etc... will stay the same, it's the breakdown below that
3. Another issue is how can the email object columns be preserved so that they are aligned right
within the column and visible and accessible with the blackberry as well as on a regular computer. I noticed within the forum
that someone said it can be done, but it does not go into detail. Can I do this using the Times New Roman font?
4. Finally, I need to have the file attach to the email. I remember reading somewhere how it was done, but I'm not sure how
this would affect formatting in other areas of the email.
Any suggestions on what I can do to make this work would
be greatly appreciated! I create this email every day and it's tedious and mind numbing, and I know that excel can do it for