• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Send email and list group of data in body of email

WNErika

New Member
have a spreadsheet of invoices I am paying to my vendors. I would like to automatically send the emails at each Vendor Name change and list the invoices and amounts the check is paying. I would like the end result to look like what i have listed below. The text in the <> would correspond with my column names.


Also, I could include the check total in one of the columns but it would repeat for any invoice listed on the same check...I just need the email to include the check amount once. Not sure if it is easier to have it do a calculation (i.e. sum) or if it can pull the check total just once. I can provide a sample of the data as well


Hello <name>


Account #: <account>


Check number: <check>


Amount: ***any way to get a sum of the amounts listed below??**


To be mailed: <date>


The check above will be paying for the following invoices:


<invoice> <amount>

<invoice> <amount>

<invoice> <amount>
 
the top part should be easily accomplished using the MailMerge Feature in Word... the only part im not 100% about is the ability for the invoice breakdown...easily at least... i mean you could have each invoice # and amount in a different column. (Invoice1, Amount1, invoice2, amount2, etc) and make it work like that.
 
Would you mind showing me how I would accomplish that? I have tried it a million times and all it does is send each invoice individually... not really ideal if we are paying 100+ invoices to one vendor.


I use mail merge now, but i can only get it to do what i want as a "directory" , not via "email". (below is my sample data - I don't see a way to attach the file, so you would need to paste it into Excel if you wanted)


VENDOR NAME INVOICE CHECK AMOUNT DATE EMAIL

Erika Erika Smith 123548 066814 $25.00 01/04/13 Erika@nowhere.com

Erika Erika Smith 123609 066814 $100.00 01/04/13 Erika@nowhere.com

Erika Erika Smith 128727 066814 $95.00 01/04/13 Erika@nowhere.com

Erika Erika Smith 129396 066814 $95.00 01/04/13 Erika@nowhere.com

Anne Anne Jones 3494551 066818 $14.96 01/04/13 anne@nowhere.com

Anne Anne Jones 3577808 066818 $245.01 01/04/13 anne@nowhere.com

Anne Anne Jones 3578747 066818 $153.54 01/04/13 anne@nowhere.com

Anne Anne Jones 3578748 066818 $17.06 01/04/13 anne@nowhere.com

Anne Anne Jones 3587899 066818 $102.36 01/04/13 anne@nowhere.com

Anne Anne Jones 3596543 066818 $71.94 01/04/13 anne@nowhere.com

John John Doe 2012 12 066939 $123.45 01/04/13 john@nowhere.com
 
i'll have to re-aquaint myself with mailmerge and will report if i find anything helpful.


this may be helpful!!

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665
 
Good day WNErika


You may find this link of use


http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/
 
Back
Top