We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Lotus Notes - reading stationery from Excel VBA

rmg1
rmg1 Posts: 3,159 Forumite
Part of the Furniture 1,000 Posts Name Dropper
Hi guys

I'm in the middle of creating an auto-mailer via Excel VBA for work (and got most of it working) but I've run across a small(ish) snag.

To save me about 3 hours work, I need to get the subject of the stationery, the "To" list, the "CC" list, the "BCC" list and the message body text (they are all slightly different) for every stationery (currently around 150).

Is there any way of getting VBA to read all the stationeries on our inbox (it's shared) and giving me the info I need?

Thanks in advance
:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:

Any posts are my opinion and only that. Please read at your own risk.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.1K Banking & Borrowing
  • 253.5K Reduce Debt & Boost Income
  • 454.2K Spending & Discounts
  • 245.1K Work, Benefits & Business
  • 600.7K Mortgages, Homes & Bills
  • 177.5K Life & Family
  • 258.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.