Excel VBA email with cells

[andy_magana]

I have a spread sheet with three columns, column A, column B, column C. Column C has expired dates. What I need is to get an email created with Excel VBA to include in the message the information from the cells from columns A and B. If the Excel VBA module can also take the expired date from Column C and send an email with a future date 11 months ahead of Column C.

I want my emails to say:

Subject: Atlassian "Cell B"
Body/Message: "Cell A" "Cell B" License will be due for renewal.

Thanks.

 

[Macropod]

You could use mailmerge from Word. No code required. For the future date, you could either add that to column D via a formula, or use field coding in Word. For the field coding approach, check out my Microsoft Word Date Calculation Tutorial, at:
Microsoft Word Date Calculation Tutorial
or:

Graham Mayor - Downloads

A collection of tips and add-ins to benefit Word users.

www.gmayor.com

In particular, look at the items titled Calculate a month and year, using n months delay and Calculate a day, date, month and year, using n months delay. Do read the document's introductory material.

 

[andy_magana]

Is efficient to just do this from Excel VBA ? I thank you very much for your time. Happy Mothers Day!

 

[Macropod]

It can be efficient, but takes a lot more work and is way harder (if not impossible) for anyone who isn't conversant with VBA to maintain.