Populate an Outlook 2007 template with spreadsheet data.

Status
Not open for further replies.
I need some basic advice about whether this is at all possible, and if so, what it would entail.




I have a form, it spits data to a spreadsheet. (Currently both are hosted on the web, but could both be hosted on local servers.)




I'd like an Outlook template to automagically populate with specific data from the spreadsheet. I'd want to be able to do this once a week with the new information submitted to the spreadsheet.




E.G.




Spreadsheet data:




1. John Accounting I love accounting


2. Sam Warehouse Betty has a new dog


3. Skip Operations I prefer tea, not coffee


4. Joe Accounting I was late to work on Sunday.


5. Sara Operations Red is not my favorite color.






E-mail:




Dear Boss,




Here is what folks had to say about their workgroups:




Accounting



* I love accounting
* I was late to work on Sunday




Operations



* Red is not my favorite color
* I prefer tea, not coffee




Warehouse



* Betty has a new dog.




Is this technically possible? I have beginner's experience with VB, but I'm a very zippy learner. I'm curious right now if this is technically a possibility. If so, can someone point me in the right direction?




Thank you very much for any help, in advance!
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
It's possible.

I'd use a class module as a collection for what the people have ot say:

<workgroup.cls
Public Name$

Private m_Text$

Public Sub AddText(Text$)

m_Text = m_Text & Text & vbcrlf

End Sub

Public Function GetText() as String

GetText=m_Text

End Sub

</workgroup.cls
In another module hold the collection of workgroup objects etc.:

Private m_Workgroups as New VBA.Collection

Public Sub ReadWorksheed()

On Error Resume Next

' open the worksheet, and read its content, that is in a loop walk through

the rows

' then add each row to a workgroup object, for instance read the second

column into the Name variable, and the third into the Text variable

Dim Name$, Text$

Dim wg as workgroup

Do While... ' loop through the rows

Set wg=m_Workgroups(Name)

If Err Then

' That group doesn't exist yet

Err.Clear

Set wg=New Workgroup

wg.Name=Name

wg.AddText Text

m_workgroups.Add wg,Name

Else

wg.AddText Text

Endif

Wend

For reading a worksheet, in Excel see the Workbooks.Open function, the Range

object, and the Range.Offset function.

Best regards

Michael Bauer

Category Manager - Easily share your categories:

SAM - Automatically choose sending account, signature, and sent message

folder:

Am Wed, 26 May 2010 15:12:00 -0400 schrieb Gwendolyn3883:


> I need some basic advice about whether this is at all possible, and if
> so, what it would entail.

> I have a form, it spits data to a spreadsheet. (Currently both are
> hosted on the web, but could both be hosted on local servers.)

> I'd like an Outlook template to automagically populate with specific
> data from the spreadsheet. I'd want to be able to do this once a week
> with the new information submitted to the spreadsheet.

> E.G.

> Spreadsheet data:

> 1. John Accounting I love accounting
> 2. Sam Warehouse Betty has a new dog
> 3. Skip Operations I prefer tea, not coffee
> 4. Joe Accounting I was late to work on Sunday.
> 5. Sara Operations Red is not my favorite color.

> E-mail:

> Dear Boss,

> Here is what folks had to say about their workgroups:

> Accounting

> * I love accounting
> * I was late to work on Sunday

> Operations

> * Red is not my favorite color
> * I prefer tea, not coffee

> Warehouse

> * Betty has a new dog.

> Is this technically possible? I have beginner's experience with VB, but
> I'm a very zippy learner. I'm curious right now if this is technically a
> possibility. If so, can someone point me in the right direction?

> Thank you very much for any help, in advance!

> ----------------------------------------------------------------------> ?t=45790

> https://forums.slipstick.com
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Pre populate subject + body + attachment to already open email in outlook 2007 Using Outlook 2
cbufacchi Outlook 365 Populate custom Outlook Appoint form Outlook VBA and Custom Forms 2
B Outlook 365 Populate Outlook Task UDFs from a UDF text string Outlook VBA and Custom Forms 2
D Cannot populate certain UserProperties in Outlook from Excel Outlook VBA and Custom Forms 2
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
Diane Poremsky Outlook VBA: Use a Text File to Populate a ListBox Using Outlook 0
A Populate Excel from Outlook Userform Outlook VBA and Custom Forms 3
J populate word template from Outlook custom form Outlook VBA and Custom Forms 2
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
A Populate Listbox from Txt File Outlook VBA and Custom Forms 0
A Populate Textbox from Txt File Outlook VBA and Custom Forms 1
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
T populate calendar with appointments and send reminders Using Outlook 1
J Live Meeting Location populate from body Outlook VBA and Custom Forms 4
A How can I populate a dropdown list? BCM (Business Contact Manager) 4
rohit I want to Populate Popup box while sending any email with attachment. Outlook VBA and Custom Forms 4
rohit I want to Populate Popup box while sending any email with attachment Using Outlook 1
A Cannot populate IMAP folders Using Outlook 1
S Populate textbox values from one form to another form. Using Outlook 0
B Auto Populate From Field Using Outlook 3
R Populate Form with appointments from Calendar Outlook VBA and Custom Forms 1
G Populate BCC field with all Contacts within a Contact Folder Outlook VBA and Custom Forms 4
M Create new Contacts folder and populate it from Access Outlook VBA and Custom Forms 1
A Macro - Open new message, populate from and subject fields, and message text Outlook VBA and Custom Forms 1
G Macro: Create New Message and Auto populate To Field Outlook VBA and Custom Forms 5
S populate body with Word data Outlook VBA and Custom Forms 7
L how to populate multiple users contacts Outlook VBA and Custom Forms 9
A Populate task field based on value of other field Outlook VBA and Custom Forms 9
G Outlook Express (DBX) to Outlook (PST) Conversion Software Wanted Using Outlook 0
J Outlook 2016 Can't display some embedded HTML images in Outlook 2016 Using Outlook 2
J Outlook EAS protocol version Using Outlook 1
N Outlook 2021 'Run Script" Rules? Outlook VBA and Custom Forms 4
C Why does Outlook (desktop) 365 for Windows keep making me input my passwords? Using Outlook 8
P Comcast IMAP broken but their second level support said to call "the Outlook company" Using Outlook 4
bdsermons Outlook 365 command button in outlook form Outlook VBA and Custom Forms 4
B iCloud telling me my Outlook is not supported Using Outlook 2
cheapfaremart Which outlook version is best? Using Outlook 0
T Outlook 2021 Cannot open attachments Outlook DeskTop 2021 Using Outlook 0
M Outlook settings will not accept a password Using Outlook 9
C Outlook FROM ADDRESS -Outlook.com and Android Using Outlook 1
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
O How to find and replace a word in Outlook-Agenda-Subject and Message? Using Outlook 0
gproston Why doesn't Outlook remember indexing? Using Outlook 1
X Open Hyperlinks in an Outlook Email Message (Help with Diane's solution) Outlook VBA and Custom Forms 3
J Outlook 2003 .pst Will Not Restore Completely to Outlook 2019 Using Outlook 5
R Outlook Logging Using Outlook 6
e_a_g_l_e_p_i Email notifications changed with Outlook 2021 Using Outlook 8
Y Disable Microsoft Outlook Test Message Using Outlook 5
J Outlook 365 Outlook 2016/365 Contacts Lose Info when Favorited to the To-Do Bar Using Outlook 2
Commodore Are newer versions of Outlook still "less secure" to Google? Using Outlook 22

Similar threads

Top